Export

  • Thread starter Thread starter Mrbanner
  • Start date Start date
M

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?
 
Hi

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