+ Reply to Thread
Results 1 to 5 of 5

Abbreviations to full Words

  1. #1
    Registered User
    Join Date
    02-05-2011
    Location
    Lodi, CA
    MS-Off Ver
    Excel 2007
    Posts
    22

    Abbreviations to full Words

    I need to change certain abbreviations to full words. not all cells contain abbreviations. I have in column A the abbrev and in column B i have the full word counterpart, and in column I i have the list of data to look through. I can move the columns around if neccessary.

    Examples:

    MTG
    BK
    ASSN

    to

    Mortgage
    Bank
    Association

    Thank You in advance
    Last edited by sparky101747; 02-08-2011 at 03:41 PM.

  2. #2
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: Abbreviations to full Words

    Can you post a sample file with before/after etc...

    How many abbreviations do you have to cater for ?

    More than half a dozen and I would say realistically you're looking at another UDF or Sub Routine if you prefer to update all cells simultaneously (probably more sensible).

  3. #3
    Registered User
    Join Date
    02-05-2011
    Location
    Lodi, CA
    MS-Off Ver
    Excel 2007
    Posts
    22

    Re: Abbreviations to full Words

    Thank You for your response
    Basically as in the sample file, if Column I contains the exact abbreviation that is in column A i just want that to be replaced with the fullword in column B. The changes can be made in the same column or if that doesn't work the results can be in Column H but if the result moves to column H then I would need the data (even the words that don't change) in column I moved as well so it would en up looking like column J in the sample.

    If it is not found = do nothing
    if there are other words or abbreviations in the cell = do nothing

    I hope I make sense. Thanks again for looking
    Attached Files Attached Files

  4. #4
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: Abbreviations to full Words

    One possibility which should avoid issues re: partial matching etc...

    Please Login or Register  to view this content.
    the above when run would overwrite original values in Column I with revised strings per the abbreviations table.

  5. #5
    Registered User
    Join Date
    02-05-2011
    Location
    Lodi, CA
    MS-Off Ver
    Excel 2007
    Posts
    22

    Re: Abbreviations to full Words

    That works! Thanks again DonkeyOte. I wish I knew half of what you do or even some of the stuff you have forgotten.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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