Export

[Mrbanner]

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]

Hi

Select column A>Data>Text to Columns>Delimited>Next>Other> put - in box next
to other>Finish