| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pull Out Last Name
Hi:
I am looking for a function in Excel to extract the LAST NAME from a cell that looks like: Justin Kenney I want the formula to give me only the last name (ie Kenney) Can anyone help with a formual (maybe the RIGHT function) that looks RIGHT TO LEFT for the 1st space...and then gives me everything to the RIGHT of the space Thanks Warren |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| hyper links in pull down menus | Excel Discussion (Misc queries) | |||
| Personal macro file will not pull up when excel is started | Setting up and Configuration of Excel | |||
| Referencing multiple criteria to pull data | Excel Discussion (Misc queries) | |||
| Not all data in AutoFilter pull down | Excel Worksheet Functions | |||
| Why does AutoFilter not show all the data in the pull down? | Excel Discussion (Misc queries) | |||
Threaded Mode
