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

  • Thread starter Thread starter Richard Yim
  • Start date Start date
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...
 
Highlight the column, then do Data > Text to columns > Delimited > next >
and use "space" as your delimiter......

Vaya con Dios,
Chuck, CABGx3
 
Thanks Chuck for the information! It sure was easy. and
would you believe I wasted almost a few hours trying to
figure out myself?
 
We're happy to help, Richard.........keep coming back and "thanks for the
thanks".....

Vaya con Dios,
Chuck, CABGx3
 
Back
Top