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.

--
Daryl S


"stumped in atl" wrote:

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?