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 _.
|