mid command to locate commas

[steve]

I have a table with a name field that looks like this:

jones, rhonda
buckley, riley
adams, bill
jefferson, tom

I want to create two new fields: one for first name, one
for last name. Can the mid command (or some version of
the 'len', 'trim' commands) locate the comma and give me
all characters prior to the comma for the last name, and
all characters beyond the comma for the first name?

I want my output to be in these two fields:
LAST NAME FIRST NAME
jones rhonda
buckley riley
adams bill
jefferson tom

 

[Harald Staff]

Hi

Use text to columns for that:
http://www.dicks-blog.com/excel/2004/08/text_to_columns.html

if not you can play with functions like
=LEFT(A1,FIND(",",A1)-1)

HTH. Best wishes Harald

 

[sss]

Thanks for the quick reply... I'll give this a try.