how to seperate data from 1 cell into multiple cells?

  • Thread starter Thread starter Lloyd
  • Start date Start date
L

Lloyd

How can I take a cell that contains a name and title and
seperate it into 3 cells?

e.g. 1 cell with John Smith, M.D. into 3 cells?

Thanks

Lloyd
 
Select the cell, use Data/Text to Columns, click Delimited, then select Space and Finish.
 
Lloyd said:
How can I take a cell that contains a name and title and
seperate it into 3 cells?

e.g. 1 cell with John Smith, M.D. into 3 cells?

Thanks

Lloyd
Click to expand...

I gave this to my class...
on the menubar,

Data: Text to Columns

Graham Hall, tutor
(from Roger Jackson student)
 
Back
Top