| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Remove part of string
I have a list of names in the format last, first. The whole name is stored
in a variable to be sorted later. How can I remove the , first from the string before putting it in a cell? Ex. The name is Smith, John. I want to put this in cell A1 but all I want in A1 is Smith. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| vlookup part of string... | Excel Discussion (Misc queries) | |||
| delete a - if it is the last part of a string | Excel Discussion (Misc queries) | |||
| Search/Match/Find ANY part of string to ANY part of Cell Value | Excel Worksheet Functions | |||
| Extract Part of String | Excel Worksheet Functions | |||
| extracting part of string value | Excel Programming | |||
Threaded Mode
