| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I extract the last name in Excel, from a list of names lik.
Trying to extract last name from a cell (db field) which contains names like:
John Doe John B. Doe J.B. Doe Various combinations of formulas such as =Right(C17,Len(c17)-FIND(" ", C17)) Can't find the right combination to do the job. Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| Address List in Excel | Excel Discussion (Misc queries) | |||
| export excel file to outlook express contact list | New Users to Excel | |||
| How do I put a list of names and e-mail addresses in excel so tha. | Excel Discussion (Misc queries) | |||
| How do I import a Windows Explorer list into Excel? | Excel Discussion (Misc queries) | |||
Threaded Mode
