+ Reply to Thread
Results 1 to 2 of 2

Replace multiple entries

  1. #1
    Registered User
    Join Date
    11-22-2022
    Location
    Grand Island
    MS-Off Ver
    365
    Posts
    1

    Replace multiple entries

    Hello.

    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.

  2. #2
    Administrator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 365 Version 2211 (Build 15813.20002) Win 11 Home 64 Bit
    Posts
    22,086

    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.
    Alan


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. If multiple entries, sum of entries, but in order by date
    By Inventory_Manager in forum Excel General
    Replies: 2
    Last Post: 08-24-2016, 07:34 PM
  2. Replies: 1
    Last Post: 04-05-2016, 11:20 AM
  3. to find and replace multiple entries
    By skarthickbabu in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-17-2014, 07:20 AM
  4. Search and replace - multiple entries
    By sandblov in forum Excel General
    Replies: 1
    Last Post: 11-29-2013, 06:41 AM
  5. [SOLVED] Automatically add multiple original field entries total (that has multiple entries)
    By steverokh in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-04-2013, 01:20 AM
  6. Replies: 11
    Last Post: 09-19-2012, 08:04 PM
  7. Using VBA: I have a list with multiple entries.Need to reduce down to unique entries
    By welchs101 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 05-25-2011, 03:19 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1