| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Delete a string
Hi,
This will leave the text you want in the existing column Data|Text to columns Select delimited Next Check 'Other' and enter an underscore in the 'other' box Finish If you don't want to keep the trailing bit then delete the column. Mike "Joe Gieder" wrote: I have a long list of numbers taht all look similar to this M7885/2-4-02_- x 2 andI want to remove everything from the _ to the end. I think I want to use Find, Replace and Length in a formula to get only the first part. One thing is the length varies behin the _. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| delete a - if it is the last part of a string | Excel Discussion (Misc queries) | |||
| DELETE ROWS FROM XLS IF THE ROW CONTAINS THE STRING | Excel Discussion (Misc queries) | |||
| Use a formula to delete part of a text string? | Excel Worksheet Functions | |||
| can I delete the 1st number from a string of numbers | Excel Discussion (Misc queries) | |||
| Delete carrots in a string | Excel Worksheet Functions | |||
Threaded Mode
