| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Splitting 1 cell into 2 based on underscore in text
Hello All,
Can someone please help me? I am trying to split one cell into two by dividing it at the first underscore in the text. I don't know how many characters will be before or after each first underscore. For example, Cell A below would be divided into cells B and C with the first underscore being eliminated. Cell A Cell B Cell C 1-DEPRASST_TRANS 1-DEPRASST TRANS 1-ACC2-DEPR_TRANS 1-ACC2-DEPR TRANS 2-OTHDED_SHOLD_EXP 2-OTHDED SHOLD_EXP 1-OTHCURRL_DEFINCOME 1-OTHCURRL DEFINCOME I've been trying all kinds of formulas in cells B and C with no luck. This has been driving me crazy. Thank you in advance. RJF |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Matching Text with With Certain Criteria | Excel Worksheet Functions | |||
| Locate a cell, based on a criteria, then use the 'Cell' command... | Excel Discussion (Misc queries) | |||
| Text on cart based on data in a cell | Charts and Charting in Excel | |||
| Split Long Text Cell into Two Shorter Cells Without Splitting Word | Excel Discussion (Misc queries) | |||
| I am trying to link based on a text value instead of cell position | Links and Linking in Excel | |||
Threaded Mode
