Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-18-2011, 01:42 PM
shabbaranks shabbaranks is offline Help with find and replace or query and replace Windows 7 64bit Help with find and replace or query and replace Office 2007
Advanced Beginner
Help with find and replace or query and replace
 
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
  #2  
Old 03-18-2011, 01:55 PM
Kimberly Kimberly is offline Help with find and replace or query and replace Windows 7 64bit Help with find and replace or query and replace Office 2010 64bit
Expert
 
Join Date: May 2010
Posts: 517
Kimberly is on a distinguished road
Default

are you looking for the Replace command? Home tab, on the right side of the window, or ctrl + H
Reply With Quote
  #3  
Old 03-18-2011, 02:00 PM
shabbaranks shabbaranks is offline Help with find and replace or query and replace Windows 7 64bit Help with find and replace or query and replace Office 2007
Advanced Beginner
Help with find and replace or query and replace
 
Join Date: Mar 2011
Posts: 89
shabbaranks is on a distinguished road
Default

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
Reply With Quote
  #4  
Old 03-19-2011, 02:09 AM
Colin Legg's Avatar
Colin Legg Colin Legg is offline Help with find and replace or query and replace Windows 7 32bit Help with find and replace or query and replace Office 2010 32bit
Expert
 
Join Date: Jan 2011
Location: UK
Posts: 369
Colin Legg will become famous soon enough
Default

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.
Code:
Code       Name
Brian012   Briancleaning012
Ber01      Bervaille01
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.
Reply With Quote
  #5  
Old 03-19-2011, 08:38 AM
shabbaranks shabbaranks is offline Help with find and replace or query and replace Windows 7 64bit Help with find and replace or query and replace Office 2007
Advanced Beginner
Help with find and replace or query and replace
 
Join Date: Mar 2011
Posts: 89
shabbaranks is on a distinguished road
Default

GREAT... Will give this a bash appreciate the efforts
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Help with find and replace or query and replace Find/Replace problems MommyO Word 1 03-09-2011 05:47 PM
Help with find and replace or query and replace Advanced find and replace anno1404 Word 1 10-21-2010 03:58 AM
find and replace anil3b2 Word 0 08-03-2010 11:30 PM
help with find and replace sjkiss Word 1 04-12-2010 08:08 AM
Find /Replace Help ilcaa Word 2 11-02-2009 08:41 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:40 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft