Deleting or removing text from a line

[herbc0704]

I have a spreadsheet where I have to remove partial text for lines. I have seen this somehere before using the find and len functions but I can't fid the thread again.

Anyway, here is the problem.

I have inventory descriptions


Red Yarn m90
Red Yarn B753
Green Wooven Yarn X96884

In each case I need to remove right most m90, b753, x96884. I have over 60000 lines of different inventory items. What formula do I use or what thread can I find to accomplish this?

 

[Jonmo1]

So you want to see up to (and including) the word Yarn?

Try

=LEFT(A1,FIND("Yarn",A1)+3)

 

[VoG]

If it isn't always Yarn

=TRIM(SUBSTITUTE(A1,TRIM(RIGHT(SUBSTITUTE(A1," ",REPT(" ",255)),255)),""))