The first part is done with SUBSTITUTE

=SUBSTITUTE(A1," ","")

which you can use in another function.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"SupperDuck" wrote in message
...
Hi.

I have part codes in my A column.

For example 10 parts in first column. And i have all part codes in column
D
and have all prices for all codes in column E

I want to take the prices for that 10 parts and so use the vlookup.

But the codes are not in same style.

I mean in A they are as;

2G15 2144 2111
2G15 2144 2111

In first code, there is only one spece and in second there are 2.

My first question;

TRIM is used to clear the speces in front and back of of the sentence. I
want to clear all spaces in the column (not with find and replace :)) So
how
can i?

And i have the main question;

When i use the vlook function;

2t14a500td

can take the value of

2t14b500td or like it. But i want it to take the value of 2t14a500td

Why?

How can i give the correct number?