Excel - Replace differant trailing words or symbyls with key w
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???)
working hard at home wrote:
Sorry I dont get it?
if 8 = charactors. Would it not be replace with: walgreens(8)
what is (A2
Thanks Peter
"vezerid" wrote:
=LEFT(A2,x)
Here x is the length of the word in characters. LEN("Walgreen")=8
HTH
Kostis Vezerides
On Oct 31, 4:28 pm, 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
--
Dave Peterson
|