how to seperate data from 1 cell into multiple cells?

[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

 

[Guest]

Select the cell, use Data/Text to Columns, click Delimited, then select Space and Finish.

 

[Tommy Twmffat]

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

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

Data: Text to Columns

Graham Hall, tutor
(from Roger Jackson student)