cell data management

[stumped in atl]

is it possible to take a cell with a full name, john bob jones for example
and split into 3 cells easily without having to retype the information
manually?

 

[Luke M]

Data - Text to columns, delimited, use space as a delimiter.

 

[Daryl S]

Stumped -

Check out the Text to Column (under the Data menu). If you choose
Delimited, and Space, then that will split the once cell into three for you.