If the first number after desired text always begins with a digit, you
can use this array formula:

=LEFT(F9,MATCH(TRUE,ISNUMBER(--MID(F9,ROW(INDIRECT("1:"&LEN(F9))),1)),
0)-1)

Assumes your text is in F9. After pasting this formula in the formula
bar, press Ctrl+Shift+Enter to confirm (instead of regular Enter).


On Oct 31, 10:28 am, working hard at home
wrote:
How do I replace in multiple cells that start out with walgreen but have
mulitple differant endings to just walgreens.
example Walgreens5417 Q03 R 10/06WALGREENS
Walgreens5417 Q03 R 10/13WALGREENS