» Encoding a Sequence of Letters
CATEGORY - Excel Text Formulas
VERSION - All Microsoft Excel Versions
Problem:Column A contains a series of letters, column B contains matching codes for each letter.
We want to create new strings composed of the codes matching each of the letter strings shown in column D.
Solution:
Use the VLOOKUP and MID functions as shown in the following formula:
=VLOOKUP(MID(D2,1,1),$A$2:$B$7,2,FALSE)&" "&VLOOKUP(MID(D2,2,1),$A$2:$B$7,2,FALSE)&" "&VLOOKUP(MID(D2,3,1),$A$2:$B$7,2,FALSE)
Book Store:
Recommended Books:
- Retire Young, Retire Rich
- The Financial Numbers Game: Detecting Creative Accounting Practices
- Microsoft Office Xp: Advanced Concepts and Techniques: Word 2002, Excel 2002, Access 2002, Powerpoint 2002
- Investments + S&P Card + Powerweb + StockTrak discount coupon
- Microsoft Office XP Introductory Concepts and Techniques
- Getting to Yes: Negotiating Agreement Without Giving In
No comments have been submitted.
