[ExcelVBA] Abbreviations to Words

 

I have a spreadsheet with about 100,000 rows. One column contains abbreviations that I need to convert to words. Sample: A stands for watermelon, Z4 stands for orange, M8U stands for apples, etc. The abbreviations contain both letters and digits, and are between 1 and 4 characters long. There are about 30 abbreviations in all.

I know I can use a For loop to examine each cell and a Select Case statement to convert the abbreviation in a cell to a word, but I wonder if there is a tricky technique that would do the conversion more efficiently.

Thanks,
Michael Trombetta

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (1)

Recent Activity:

• New Members 2

Visit Your Group

----------------------------------
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.

----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA

----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com

----------------------------------

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___