Hi all... Im pretty rubbish at the MS products give me a server task anyday but I am on a bit of a mission.

Basically we have an output from our ordering system which exports a list of clients in spreadsheet format. What I am trying to do is replace the spreadsheet entry for example BER01 with the clients proper name Bervaille01. Another little issue is there could be "and is" a BER02 which is a different customer so I wouldnt want them to be replaced with the Bervaille details.

Each client will never change thier name but the list will grow as more clients are taken on.

A nice easy one to start with

Any help is appreciated - thanks