Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
pulling apart a field
sample field:
HYDROXYZINE PAM TYA** 2 DOE, JOHN sample output: DOE, JOHN I would like to pull out the name from the field above. Cutting point should be at the nearest space preceding the last comma. I'm having trouble wrapping my brain around it. I'd prefer to do it with functions rather than VB script, but will be glad with either solution. Your help is very appreciated. --T |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula, one field complex or multiple table field simple | Excel Discussion (Misc queries) | |||
How to make a field created a part of the Pivot Table Field List? | Excel Discussion (Misc queries) | |||
Linked date field in worksheet defaults a blank field as 1/0/1900 | Excel Worksheet Functions | |||
How to Join/concatenate a date field with a time field in Excel? | Excel Discussion (Misc queries) | |||
Q: assign field background color dynamically according to field values | Excel Programming |