Name Placement
 

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?


--
lsmft
------------------------------------------------------------------------
lsmft's Profile: http://www.excelforum.com/member.php...o&userid=30678
View this thread: http://www.excelforum.com/showthread...hreadid=517744

Name Placement
 

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" wrote:


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?


--
lsmft
------------------------------------------------------------------------
lsmft's Profile: http://www.excelforum.com/member.php...o&userid=30678
View this thread: http://www.excelforum.com/showthread...hreadid=517744

Name Placement
 

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?


--
lsmft
------------------------------------------------------------------------
lsmft's Profile: http://www.excelforum.com/member.php...o&userid=30678
View this thread: http://www.excelforum.com/showthread...hreadid=517744

Name Placement
 

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



"CLR" wrote:

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" wrote:


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?


--
lsmft
------------------------------------------------------------------------
lsmft's Profile: http://www.excelforum.com/member.php...o&userid=30678
View this thread: http://www.excelforum.com/showthread...hreadid=517744

Name Placement
 

I'm attempting to attach it now.


--
lsmft
------------------------------------------------------------------------
lsmft's Profile: http://www.excelforum.com/member.php...o&userid=30678
View this thread: http://www.excelforum.com/showthread...hreadid=517744

Name Placement
 

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

Vaya con Dios,
Chuck, CABGx3
"lsmft" wrote:


I'm attempting to attach it now.


--
lsmft
------------------------------------------------------------------------
lsmft's Profile: http://www.excelforum.com/member.php...o&userid=30678
View this thread: http://www.excelforum.com/showthread...hreadid=517744

Name Placement
 

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


--
lsmft
------------------------------------------------------------------------
lsmft's Profile: http://www.excelforum.com/member.php...o&userid=30678
View this thread: http://www.excelforum.com/showthread...hreadid=517744

Name Placement
 

Sorry.....

croberts at tampabay dot rr dot com

Put it together as would be evident....

Vaya con Dios,
Chuck, CABGx3



"lsmft" wrote in
message ...

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


--
lsmft
------------------------------------------------------------------------
lsmft's Profile:
http://www.excelforum.com/member.php...o&userid=30678
View this thread: http://www.excelforum.com/showthread...hreadid=517744