First Name Last Name in a colum. how2 divide them into two colums

R

Richard Yim

I buy names from name vendor, and usually they send me
text file that has first name in one colum and last name
in another colum.

This time they send me the first name and last name
combined (only separated by a space) in a column.

what function to use to separate the two into two columns?
i know there should be a way...
 
C

CLR

Highlight the column, then do Data > Text to columns > Delimited > next >
and use "space" as your delimiter......

Vaya con Dios,
Chuck, CABGx3
 
R

Richard Yim

Thanks Chuck for the information! It sure was easy. and
would you believe I wasted almost a few hours trying to
figure out myself?
 
C

CLR

We're happy to help, Richard.........keep coming back and "thanks for the
thanks".....

Vaya con Dios,
Chuck, CABGx3
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

first ten and last ten averages 2
splitting Last Name, First Name 4
parsing a full name out into Last, First, Middle 2
Separate first name, middle name and last name 2
Combining first and last names into one column 1
match first and last name and insert column into existing sheet 1
Looking up first and last 7
Divide "Name" into First & Last 11

Top