Maybe the OP just wanted one store <vbg.

Gord Dibben wrote:

I would use =LEFT(B2,9)

To return walgreens.........9 chars

Gord

On Wed, 31 Oct 2007 11:09:24 -0500, Dave Peterson
wrote:

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