PC Review


Reply
Thread Tools Rate Thread

Converting to FirstName LastName

 
 
mcp6453
Guest
Posts: n/a
 
      20th Oct 2008
I have a spreadsheet in Excel 2003 that includes a column of names in
"LastName, FirstName" format. I need for it to be in "FirstName
LastName" order. How can I do that without manually typing all 300 names?
 
Reply With Quote
 
 
 
 
Robert McCurdy
Guest
Posts: n/a
 
      20th Oct 2008
Text to Columns?
Do you only have 2 names for each person?

Recombine the names in the order after you swap the columns:

use
=A2&B2&C2 ... etc where A2 is the first name and the others the rest.


Regards
Robert McCurdy

"mcp6453" <(E-Mail Removed)> wrote in message news:e$(E-Mail Removed)...
>I have a spreadsheet in Excel 2003 that includes a column of names in
> "LastName, FirstName" format. I need for it to be in "FirstName
> LastName" order. How can I do that without manually typing all 300 names?

 
Reply With Quote
 
 
 
 
T. Valko
Guest
Posts: n/a
 
      20th Oct 2008
Try this:

A1 = LastName, FirstName

=MID(A1&" "&A1,FIND(",",A1)+2,LEN(A1)-1)

result = FirstName LastName

--
Biff
Microsoft Excel MVP


"mcp6453" <(E-Mail Removed)> wrote in message
news:e$(E-Mail Removed)...
>I have a spreadsheet in Excel 2003 that includes a column of names in
>"LastName, FirstName" format. I need for it to be in "FirstName LastName"
>order. How can I do that without manually typing all 300 names?



 
Reply With Quote
 
Cawshus
Guest
Posts: n/a
 
      20th Oct 2008
mcp6453 <(E-Mail Removed)> wrote in news:e$7cAQlMJHA.5428
@TK2MSFTNGP02.phx.gbl:

> I have a spreadsheet in Excel 2003 that includes a column of names in
> "LastName, FirstName" format. I need for it to be in "FirstName
> LastName" order. How can I do that without manually typing all 300 names?
>



The FIND() will give you a location to split the string at the comma:

=LEFT(A1,FIND(",",A1)-1) & RIGHT(A1,LEN(A1)-FIND(",",A1))


 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
switching lastname, firstname to firstname lastname harvey Microsoft Access Getting Started 1 24th Apr 2005 01:49 AM
FirstName LastName 2 LastName, FirstName? Ken Microsoft Outlook Discussion 5 11th Mar 2005 10:17 PM
FirstName LastName or LastName, FirstName? Mark B Microsoft Outlook Discussion 0 13th Feb 2005 10:29 PM
Address Book: FirstName LastName 2 LastName FirstName Ken Isaacson Microsoft Outlook 4 28th Dec 2004 08:49 PM
Firstname Lastname - Lastname, Firstname Gary Microsoft Access Database Table Design 3 24th Mar 2004 07:36 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 05:49 AM.