Split Text
Change column A to values first
Select column A, then Copy
EditPastespecialValues
--
HTH
RP
(remove nothere from the email address if mailing direct)
"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.
|