Prev: Autofilter Problem
Next: compare two columns and pull out differences
From: stumped in atl stumped in on 11 Feb 2010 10:49
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?
From: Luke M on 11 Feb 2010 11:17
Data - Text to columns, delimited, use space as a delimiter.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"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?
From: Daryl S on 11 Feb 2010 11:48
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?
 | 
Pages: 1
Prev: Autofilter Problem
Next: compare two columns and pull out differences