How can i split some symbol into many cells ?

  • Thread starter Thread starter kee149
  • Start date Start date
K

kee149

For example, cell A1, I have "12/3/2006" I wanna split "/" and then put
each value into A2, A3, and A4.

So, when I write the code A1, B1, C1, and so on. they will split the
value and put into each cell.

A1 = (12/3/2006) ===> A2 = 12, A3 = 2, A4 = 2006
....

How can I do this ?

Thks
Kee
 
easiest way

select column a
click data on the menu and then text to columns
click next
uncheck all boxes except other and then enter the / in the box
click next
in the destination box enter B1
 
Back
Top