| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Parse Name field with multiple characthers
I need to parse the first 7 chars of last name from name field (ie. first
last, first middle last), however the last name can have a hyphen and or multiple names. Examples: Joe De La Paz result needs to be DELAPAZJ (this one is tough because it was entered with spaces between De La Paz) Crystal Bakersmith result needs to be BAKERSMC Sally Mahone-Lamm result needs to be MAHONES Chan Ven Kaliq Kada result needs to be KADAC |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to parse long spaced entry into multiple cells??? | Excel Worksheet Functions | |||
| VBA to parse multiple links to one cell | Excel Discussion (Misc queries) | |||
| parse comma separated text to multiple cells and remove duplicates | Excel Worksheet Functions | |||
| HOW TO | *automatically* parse comma separated text to multiple ce | Excel Discussion (Misc queries) | |||
| How do you count number of characthers in a single cell? | Excel Worksheet Functions | |||
Threaded Mode
