change lname, fname to fname last name
 

I have work sheet with names listed as last name, first name, I would like to
have them as just first name last name.

Suggestions??

if your data starts in cell A1:

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


"Al Wills" wrote:

I have work sheet with names listed as last name, first name, I would like to
have them as just first name last name.

Suggestions??

Hi!

Try this:

A1 = Smith, John

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

Returns: John Smith

Biff

"Al Wills" <Al wrote in message
...
I have work sheet with names listed as last name, first name, I would like
to
have them as just first name last name.

Suggestions??

Hi JMB,

Not quite, I still get lastname, firstname lastname ~ Thanks a lot though,
the post from Biff worked fine!

Thanks a lot!

Al

"JMB" wrote:

if your data starts in cell A1:

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


"Al Wills" wrote:

I have work sheet with names listed as last name, first name, I would like to
have them as just first name last name.

Suggestions??

anoher way use -data text to columns , delimiter=, (comma) and then
concantenate B1 and A1
you can do a macro on this.

Al Wills wrote in message
...
Hi JMB,

Not quite, I still get lastname, firstname lastname ~ Thanks a lot though,
the post from Biff worked fine!

Thanks a lot!

Al

"JMB" wrote:

if your data starts in cell A1:

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


"Al Wills" wrote:

I have work sheet with names listed as last name, first name, I would
like to
have them as just first name last name.

Suggestions??