| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Remove data that preceeds a character
I have a a column of data that has 4 seperate hyphens in the text.
EX. abc-123-abc-123-BEGIN NEEDED DATA AND THIS DATA ALSO HAS HYPHENS I WANT TO KEEP. How can I remove all the data that preceeds the 4th and final hyphen and keep the needed data. The # of characters in the preceeding data varies, so the 4th hyphen ( from the left) is the only consistent measure I have. -- Thanks, Ty |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to remove character format under .csv? | Excel Discussion (Misc queries) | |||
| Remove ' character from copied excel cell to match data | Excel Discussion (Misc queries) | |||
| Remove character from imported data | Excel Discussion (Misc queries) | |||
| How to remove a character from the first index? | Excel Discussion (Misc queries) | |||
| Remove a particular character using formulas | Excel Discussion (Misc queries) | |||
Threaded Mode
