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

are you looking for the Replace command? Home tab, on the right side of the window, or ctrl + H

Im kinda looking for a guided solution as to how I achieve replacing the client names from the Brian012 which isnt specific to a client name Briancleaning012 for example.

As each client will appear maybe more than once in the list and the sheer volume of clients names, I would like to be able to query a template list which has the client names and replace the list which comes from our databse exported to an excel spreadsheet with the names from the temlpate..

Confused - I am

The best solution would be to speak with the team that manages your ordering system and ask them to include the client names you want in the export. This should be a very simple task for them.

If that's not an option then a simple way to do this in Excel would be to keep a look up table on a spare worksheet. It would contain the client codes and the corresponding Client Names, eg.
Then, in a spare column in your export worksheet, you can do use VLOOKUP() to pull in the correct name for each code. At that point you can either leave the codes and the names in the export, or you can copy > pastespecial values the names over the codes.

It's also possible to automate this using VBA but, considering both that it would be quite a steep learning curve and that the manual VLOOKUP() method is pretty quick once you've set up the look up table, it's probably worth putting to one side for now.

GREAT... Will give this a bash appreciate the efforts