Replace multiple entries
We went from Access databases (and in the minds of the suits) "upgraded" to Excel. I have used Excel frequently, but my work was essentially in Access.
So please bear with me - I have a worksheet with 1000's of entries in column A.
They are all numbers.
I want to replace the them with a text string.
For Example Column A = 12345 I want to replace with AGHJK
There are roughly 40 unique numbers in column A.
In Access - I would probably use a Select Case, but in Excel it looks like I either need a macro - which I could probably do a Find and Replace for each individual number or write some code.
I am not familiar how to write this code.
I also have a tab with Column A = the number Column B the text
Array? I know what it is but not how to use it.
Any direction for this?
Thankfully I am retiring in a year or so.
Re: Replace multiple entries
Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file and a mocked up solution.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
By Inventory_Manager in forum Excel General
Last Post: 08-24-2016, 07:34 PM
By MML3329 in forum Excel General
Last Post: 04-05-2016, 11:20 AM
By skarthickbabu in forum Excel Formulas & Functions
Last Post: 04-17-2014, 07:20 AM
By sandblov in forum Excel General
Last Post: 11-29-2013, 06:41 AM
By steverokh in forum Excel Programming / VBA / Macros
Last Post: 03-04-2013, 01:20 AM
By Yupyup in forum Excel General
Last Post: 09-19-2012, 08:04 PM
By welchs101 in forum Excel Programming / VBA / Macros
Last Post: 05-25-2011, 03:19 PM
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1