How can i split some symbol into many cells ?

[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

[Gary Keramidas]

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

--


Gary


"kee149" <[email protected]> wrote in message
news:[email protected]...
>
> 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
>
>
> --
> kee149
> ------------------------------------------------------------------------
> kee149's Profile:
> http://www.excelforum.com/member.php...o&userid=33531
> View this thread: http://www.excelforum.com/showthread...hreadid=533233
>

[JMB]

One other way

A2 = Month(A1)
A3 = Day(A1)
A4 = Year(A1)

Copy across

"kee149" wrote:

>
> 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
>
>
> --
> kee149
> ------------------------------------------------------------------------
> kee149's Profile: http://www.excelforum.com/member.php...o&userid=33531
> View this thread: http://www.excelforum.com/showthread...hreadid=533233
>
>