Thread: Delete a string
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Joe Gieder Joe Gieder is offline
external usenet poster
 
Posts: 73
Default 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 _.