| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula to pull last name error (Excel 07)
In A1 I have Joe Smith, I would like Smith to be in B1.
I tried using the function =RIGHT(A1,LEN(A1)-FIND(*,SUBSTITUTE(A1, ,*,LEN(A1)-LEN(SUBSTITUTE(A1, ,))))) but am getting the #NAME? error. FYI: I can't use the Text to Columns function because I have some names that have at least 2 middle names... Thanks -B |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula to pull last name error (Excel 07)
Maybe something like that...
[Start typing the formula(s) in column C first] http://img695.imageshack.us/img695/346/nonamer.png Micky "Outlook, eh?" wrote: In A1 I have Joe Smith, I would like Smith to be in B1. I tried using the function =RIGHT(A1,LEN(A1)-FIND(*,SUBSTITUTE(A1, ,*,LEN(A1)-LEN(SUBSTITUTE(A1, ,))))) but am getting the #NAME? error. FYI: I can't use the Text to Columns function because I have some names that have at least 2 middle names... Thanks -B |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pull formula through | Excel Discussion (Misc queries) | |||
| is anyone familiar with the pull formula in excel? | Excel Worksheet Functions | |||
| formula to pull name and amount | Excel Worksheet Functions | |||
| How do I pull the column header next to a Max formula? | Excel Worksheet Functions | |||
| Trying to pull date from field getting error. | Excel Worksheet Functions | |||
Linear Mode
