I have a 2k line excel doc witht he following
A1
Item 339393 no longer in stock - Tuesday, September 11, 2007
I need to separate the data into 2 cells
a1 b2
Text Data
how can i remove the date infomation from the field and put it in a
new cell by itself?
Roger Govier - 24 Oct 2007 06:59 GMT
Hi
Select column A>Data>Text to Columns>Delimited>Next>Other> put - in box next
to other>Finish

Signature
Regards
Roger Govier
>I have a 2k line excel doc witht he following
>
[quoted text clipped - 8 lines]
> how can i remove the date infomation from the field and put it in a
> new cell by itself?