Hi,

I written the following formula to extract data from another workbook into
my current work using IF and VLOOKUP.
=IF(B81,VLOOKUP(B8,S3.XLS!Sales,8, 0),"")

I would also like to be able to to only extract some of this information;
These are examples of the data:
Settled 4.8.04
Builders Terms B4 5.7.05

BUT I would only like to see B4 5.7.05 and not include words like Settled
and Builders Terms.

Any ideas?

Thanks