Excel - Replace differant trailing words or symbyls with key word

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
=LEFT(A2,x)

Here x is the length of the word in characters. LEN("Walgreen")=8

HTH
Kostis Vezerides
 
Sorry I dont get it?
if 8 = charactors. Would it not be replace with: walgreens(8)
what is (A2
Thanks Peter
 
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).
 
A2 is the address of the cell that contains the string:
Walgreens5417 Q03 R 10/06WALGREENS

Then try:
=left(a2,8)
in another cell (say B2???)
 
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
 
"Multiple differant prefex". If a number always follows a prefix, I
reiterate my previous solution.
 
Back
Top