| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function similar to "LEFT"
I'm trying to separate the last name from the first name in a field. I can
get the first name by using the "left" function. Does anyone know how to get the last name? I tried using "right" function but on some it gives me the whole last name plus part of the first name, others it gives me some of the letters of the last name. Please advise - thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Text "comparison" operator for "contains" used in an "IF" Function | Excel Worksheet Functions | |||
| "If" function or similar | Excel Worksheet Functions | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
| Adding a period to the "=LEFT()" function. | Excel Worksheet Functions | |||
Threaded Mode
