Thread: Delete a string
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default 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 _.