Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
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
Reply



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 06:49 PM.


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