| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Delete a string
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 _. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Delete a string
You can do 2 things..
1) Find, enter "_*" without the quote , Replace, leave the space blank. Replace All The * will remove everything after _ Or, to make it a formula, =LEFT(A2,FIND("_",A@)-1) and drag to bottom "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 _. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Delete a string
If you want to show everything in front of the underbar in a different
column, you can use this formula... =LEFT(A1,FIND("_",A1)-1) If you want to physically modify the existing entry, you will need a VBA macro for that. -- Rick (MVP - Excel) "Joe Gieder" wrote in message ... 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 _. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Delete a string
Try this:
=LEFT(A1,FIND("_",A1)-1) Hope this helps. Pete On Oct 3, 6:37*pm, 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 _. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Delete a string
"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 _. |
|
#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 _. |
| Reply |
| 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 | |||
Linear Mode
