| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Get characters on left of specified character in Excel
In an Excel column I am having values like
A1 - abcd - abcdedfg A2 - abc - zyxwvu A3 - ab - mnopq I need a formula to get all characters left of the hypen for each value in another column. Hypen may occur in any position (except first). Any pointers? Thanks in Advance |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Returning left part of cell before a character | Excel Discussion (Misc queries) | |||
| Limit character count in cell from left | Excel Discussion (Misc queries) | |||
| How to edit column data so that all but left most character remain | Excel Discussion (Misc queries) | |||
| Extracting a character from a string of characters | Excel Discussion (Misc queries) | |||
| HOW DO I EXTRACT ALL CHARACTERS AFTER 5 CHARACTERS ON LEFT | Excel Worksheet Functions | |||
Threaded Mode
