| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| graphics placement | Excel Worksheet Functions | |||
| Pivot Table custom column placement | Excel Discussion (Misc queries) | |||
| Cursor placement | New Users to Excel | |||
| Category Axis placement | Charts and Charting in Excel | |||
| Auto placement of date | Excel Discussion (Misc queries) | |||
Linear Mode
