dynamic truncuation

[Victtor]

I found this formula:

=LEFT(A1, FIND("?", A1&"?")-1)

that removes everything after a question mark including the question mark.

I need the formula to remove everything after the first number after the last alpha character in a cell:

3 examples:

2011617 Nacho Bar 206 42.83% 1,260.19 68.32% (remove everything after the 206)

2011618 rice 2 0.42% 0.02 0.00% (remove everything after the 2)

2015716 Shrimp Etouffee 1 0.21% 4.59 0.25% (remove everything after the 1)


I would like this without using VBA code if possible. however, I will even take VBA code if that is the only option.

 

[sheetspread]

Excel 2010
	A	B
1	2011617 Nacho Bar 206 42.83% 1,260.19 68.32% (remove everything after the 206)	2011617 Nacho Bar 206
2	2011618 rice 2 0.42% 0.02 0.00% (remove everything after the 2)	2011618 rice 2
3	2015716 Shrimp Etouffee 1 0.21% 4.59 0.25% (remove everything after the 1)	2015716 Shrimp Etouffee 1
Sheet7

Cell Formulas
Range	Formula
B1	=TRIM(LEFT(A1,FIND("%",A1)-6))

 

[Scott Huish]

I don't have a fix for it yet, but that will have a problem if the percent is ever 100.00%

 

[Scott Huish]

Perhaps:

=LEFT(A1,FIND("%",SUBSTITUTE(A1,"100.00%","0.00%"))-6)

 

[Victtor]

Thanks! this worked. The percent will never be 100.00%