"Multiple differant prefex". If a number always follows a prefix, I
reiterate my previous solution.

On Oct 31, 12:07 pm, iliace wrote:
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- Hide quoted text -

- Show quoted text -



On Oct 31, 12:39 pm, working hard at home
wrote:
This is Vertical list with multiple differant prefex.I want to eliminate the
back end info words just keep front wording, using find and replace tool and
not list each sell as their are hundreds
example Walgreens5417 Q03 R 10/06WALGREENS
Walgreens5417 Q03 R 10/13WALGREENS
Become Walgreens



"iliace" wrote:
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- Hide quoted text -

- Show quoted text -