[Macpartners] need a way to separate names

[Jonathan McIndoe Hunt]

One excel trick I use is to split the cell using left and right functions
with the comma space as the character to find

Last Name, First Name in cell A1

First: =RIGHT(A1,FIND(", ",A1))
Last: =LEFT(A1,FIND(", ",A1))


Jon
__________________________________________________
Jonathan McIndoe Hunt     MIT EECS '97 617.253.0172
Manager Software Services
Client Support Services
Information Services & Technology, MIT
http://web.mit.edu/ist/topics/software/

-----Original Message-----
From: macpartners-bounces at MIT.EDU [mailto:macpartners-bounces at MIT.EDU] On
Behalf Of Phyllis Collymore
Sent: Thursday, May 03, 2007 5:06 PM
To: macpartners at mit.edu
Subject: [Macpartners] need a way to separate names

Hello,

I have been sent an excel spreadsheet which has names in the format,

last name, first name

I know how to remove the commas en mass, but do not know of a way to  
separate the first and last names easily.  Once the commas are out, I  
cut the first name out and paste it into an adjacent column.  Does  
anyone know of a way to separate the names into two columns, as I  
need to have the first and last names as separate data fields.

Thanks for any better ideas, as the cut&paste method is time consuming.

Phyllis
_______________________________________________
Macpartners mailing list
Macpartners at mit.edu
http://mailman.mit.edu/mailman/listinfo/macpartners