Name Placement

[lsmft]

Yesterday, Cheri asked about reworking name arrangement from First name
and last name in one cell, to being able to reverse the names. I have
tried to use the formula for the same situation but I am only getting
#value! in the new cell. I have swapped the formatting from text to
general and then back to text, but it hasn't corrected yet. Please
advise as to what am I doing wrong?

 

[Guest]

This modified formula of Topper's, if put in B1, will convert the value
Roberts, Charles in A1 to Charles Roberts in B1.........it can then be copied
down column B as far as you have names in column A. It will also make the
first letter of each name in upper case.

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

hth
Vaya con Dios,
Chuck, CABGx3

 

[lsmft]

I'm still getting the same result: #value!
I've copied the formula as exactly as I can see how and rechecked.
Wonder what I'm doing wrong now?

 

[Guest]

Are you using the Engilish version Excel?....if not, you may have to replace
the commas with semicolons, or whatever.........

Did you paste the entire formula all in one cell.........sometimes the email
word-wrap confuzes long formulas........

If nothing else, you can try sending your workbook to my home addy and I
will take a look.........

Vaya con Dios,
Chuck, CABGx3

 

[lsmft]

I'm attempting to attach it now.

 

[Guest]

Ok, but be sure to send it to my home addy, NOT the newsgroup........

Vaya con Dios,
Chuck, CABGx3

 

[lsmft]

Sorry but I don't see an email address anywhere and your name in not a
hyperlink either.

 

[CLR]

Sorry.....

croberts at tampabay dot rr dot com

Put it together as would be evident....

Vaya con Dios,
Chuck, CABGx3