Specific extration

[Kabous07]

Good day all clever ones, i believe i might have a thinker here.

I am struggling with something. I have over 3000 cells, like the below, each with a different code and here below is what i want to do. I want excel to "scan" from A2-A3002 in B2-B3002 respectively. The results in column B must be a description(Which i obviously have to create a data base, like for instance "ANL-Air cooled chiller" and then ANL***P-Air cooled chiller with low head pump)

Unit	Description
ANL020	Air cooled chiller
ANL020P	Air cooled chiller with low head pump
ANL020A	Air cooled chiller with low head pump and buffer tank
ANL020H	Air cooled heatpump
ANL020HP	Air cooled heatpump with low head pump
ANL020HA	Air cooled heatpump with low head pump and buffer tank
ANL030	Air cooled chiller
ANL030P	Air cooled chiller with low head pump

<tbody>
</tbody>

Please let me know. I really do not want to type(copy paste) everything over 3000 times

 

[Kabous07]

Re: Specific extraction

Oh yes. According to my catalog, there will be only one digit yes.

As for the data base i have not compiled yet. i only have did the examples. If you want, i can actually mail it for to you.

 

[mfexcel]

Re: Specific extraction

ok. can i conclude that your data following this pattern: MODEL#######DATA#

Where MODEL is pure character only
#### is pure number string with numbers only
DATA# is what you want to look up in another data table that you are still working on; and it may end with a single digit number?

Oh yes. According to my catalog, there will be only one digit yes.

As for the data base i have not compiled yet. i only have did the examples. If you want, i can actually mail it for to you.