| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
To only get all text after a comma
I need a function to obtain just the first name from a cell but the cell has
the name written as: Smith, Jack I tried the the MID function but it requires a number to be entered to dictate where it will start gathering the info. from. I will never know how long their surname is so I would like something that will find the comma. Then collect the first name Jack for example from the comma. Can anyone help please. Sue |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cell text based on 4 condition test | Excel Worksheet Functions | |||
| Text Wrapping | Excel Discussion (Misc queries) | |||
| SUMPRODUCT vs Text??? | Excel Worksheet Functions | |||
| Autofitting a row | Excel Discussion (Misc queries) | |||
| Read Text File into Excel Using VBA | Excel Discussion (Misc queries) | |||
Threaded Mode
