Try these text formulas:

In B1,
=LEFT(A1,FIND(",",A1)-1)

In C1,
=RIGHT(A1,LEN(A1)-FIND(",",A1))

--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"Gabe" wrote in message
...
I am trying to split data from one cell to another, I tried using the TEXT
To
COLUMNS wizard but it wants to split the cell as a formula instead of the
value.

A1 =Sheet1!A1
A1 displays the value (please,help)

How can I split the value of A1 into A2 and A3?

Any help is greatly appriciated. Thanks.