"Annerobbo" wrote:

Hi I probably wasn't very clear!!!

On sheet 1 in cell E7 to E700 it may have A0014A to A0014G. Depending what
is in that cell on sheet 3 in the same workbook I need to convert this to a
different number eg A0014A will become W123, A0014B will become ENG, A0014C
will become FF37, A0014D will become FF46, A0014E will become Route 3, A0014F
will become Piccadilly and A0014G will become SWIM 111. Hope this is more
explainatory.

Thanks