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