thanks for responding.

I cant do the mid/left/right function. Because the postion of the vendor
name inthe reference column varies.

Dec-05 Reversing Accrual--DOME PRINTING & LITHOGRAPH----Upfront
Postage-January regional direct mail campaign
Dec-05 Reversing Accrual--DOME PRINTING & LITHOGRAPH----Upfront
Postage-January regional direct mail campaign
Nov-05 Reversing Accrual--ZANG--10950--Plasma Direct Mail Sweepstakes -
Postage
Nov-05 Reversing Accrual--ZANG--10950--Plasma Direct Mail Sweepstakes -
Postage

The aboe are the values in Column A. Column B has the venodr names. Some
items in coulmn A has the vendor name already indicated in column B. But some
lines like the above doesnt have the vendor name. It is blank in column b.

In the above the vendor names are Dome Printing & LIthograph in the first
two and in the next two, the vendor name is ZAng. I wish to have these vendor
names beside it, in column b.

Hope the above is clear.

thanks again,
del
Subject: vlook up 1/25/2006 1:39 PM PST

By: CLR In: microsoft.public.excel.misc


The Vendor's names can probably be extracted out of your column A using the
TEXT functions of LEFT, RIGHT, MID, etc.....but the exact method depends
heavily on what your data looks like. Is there any similarity of the data
in column A?
Post a few typical cell values and it will give us a better idea......(use
phoney names if you wish, but keep the structure the same)

Vaya con Dios,
Chuck, CABGx3



"arcticale" wrote in message
...
I want to sort my spreadsheet using the venod me. however not all lines
have
vendor name. Rather, the vendor name is within the text in column a.
Usually
in the middle. Is there a way to do a vlookup and say the vendor name of
all
in column a that contains the word 'elite' is "Elite Services?

If I do a vlook up, what should be the formula. If it's not possible in
vlook up, is there anyway i can do this.

thanks,
del

=MID(A1,FIND("--",A1,1)+2,FIND("--",A1,FIND("--",A1,1)+1)-FIND("--",A1,1)-2)

Vaya con Dios,
Chuck, CAVGx3



"arcticale" wrote:

thanks for responding.

I cant do the mid/left/right function. Because the postion of the vendor
name inthe reference column varies.

Dec-05 Reversing Accrual--DOME PRINTING & LITHOGRAPH----Upfront
Postage-January regional direct mail campaign
Dec-05 Reversing Accrual--DOME PRINTING & LITHOGRAPH----Upfront
Postage-January regional direct mail campaign
Nov-05 Reversing Accrual--ZANG--10950--Plasma Direct Mail Sweepstakes -
Postage
Nov-05 Reversing Accrual--ZANG--10950--Plasma Direct Mail Sweepstakes -
Postage

The aboe are the values in Column A. Column B has the venodr names. Some
items in coulmn A has the vendor name already indicated in column B. But some
lines like the above doesnt have the vendor name. It is blank in column b.

In the above the vendor names are Dome Printing & LIthograph in the first
two and in the next two, the vendor name is ZAng. I wish to have these vendor
names beside it, in column b.

Hope the above is clear.

thanks again,
del
Subject: vlook up 1/25/2006 1:39 PM PST

By: CLR In: microsoft.public.excel.misc


The Vendor's names can probably be extracted out of your column A using the
TEXT functions of LEFT, RIGHT, MID, etc.....but the exact method depends
heavily on what your data looks like. Is there any similarity of the data
in column A?
Post a few typical cell values and it will give us a better idea......(use
phoney names if you wish, but keep the structure the same)

Vaya con Dios,
Chuck, CABGx3



"arcticale" wrote in message
...
I want to sort my spreadsheet using the venod me. however not all lines
have
vendor name. Rather, the vendor name is within the text in column a.
Usually
in the middle. Is there a way to do a vlookup and say the vendor name of
all
in column a that contains the word 'elite' is "Elite Services?

If I do a vlook up, what should be the formula. If it's not possible in
vlook up, is there anyway i can do this.

thanks,
del