Re: First name, Last name in seperate columns

Giganews Newsgroups
Subject: Re: First name, Last name in seperate columns
Posted by:  Bob Phillips (bob.N…@googlemailxxx.com)
Date: Wed, 3 May 2006

Insert a column at B.
Select column A.
Data>Text To Columns and use a delimiter of space.

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"Capt_Trips" <Capt_Trips.278giy_1146662100.737@excelforum-nospam.com> wrote
in message news:Capt_Trips.278giy_1146662100.737@excelforum-nospam.com...
>
> Hello,
> I have a very large spreadsheet with customer information...Company,
> Name, Address, City, etc etc...The problem is that Name is first name
> and last name in one column...I would like to have first name in one
> column and last name in another. Is there any way to do this without
> copying and pasting 25,000 names?
> Any help would save me days of work
> Thanks
> John
>
> --
> Capt_Trips
> ------------------------------------------------------------------------
> Capt_Trips's Profile:
http://www.excelforum.com/member.php?action=getinfo&userid=34080
> View this thread:http://www.excelforum.com/showthread.php?threadid=538429

Replies

None

In response to

First name, Last name in seperate columns posted by Capt_Trips on Wed, 3 May 2006