Seperate First and Last Name into different cells
 

I have a column of names with the first name followed by a space and the last
name. I need to put these into 2 different columns, one column the first
name and the other the last name. Could you please help me?

Sam, have a look at data, text to columns, post back if you need more help
with this
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Sam555" wrote in message
...
I have a column of names with the first name followed by a space and the
last
name. I need to put these into 2 different columns, one column the first
name and the other the last name. Could you please help me?

Select the range of names. Datatext to columns delimited, delimiter is
space. .. finish.


"Sam555" wrote in message
...
I have a column of names with the first name followed by a space and the
last
name. I need to put these into 2 different columns, one column the first
name and the other the last name. Could you please help me?

Insert a couple of extra columns to the right of the column with the names.

Select the column with the names and do
Data|Text to columns
delimited
by space

and see if that works for you.

Sam555 wrote:

I have a column of names with the first name followed by a space and the last
name. I need to put these into 2 different columns, one column the first
name and the other the last name. Could you please help me?

--

Dave Peterson

Menu DataText To Columns with space as a delimiter.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Sam555" wrote in message
...
I have a column of names with the first name followed by a space and the
last
name. I need to put these into 2 different columns, one column the first
name and the other the last name. Could you please help me?

use Text to Column Options and Split it using De limited with Delimiter as
space

"Sam555" wrote:

I have a column of names with the first name followed by a space and the last
name. I need to put these into 2 different columns, one column the first
name and the other the last name. Could you please help me?