View Single Post
 
Old 03-18-2011, 01:42 PM
shabbaranks shabbaranks is offline Windows 7 64bit Office 2007
Advanced Beginner
 
Join Date: Mar 2011
Posts: 89
shabbaranks is on a distinguished road
Default Help with find and replace or query and replace

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
Reply With Quote