How do I convert numbers to words in Excel

G

Guest

I have a series of single digit numbers and single alphabetic characters.
Each stands for a different corporate title. How do I convert the numbers and
alpha characters to the appropriate title -- 1=Owner, C=CEO, etc.
 
G

Guest

I'm not sure if you mean by conversion, replacing, or you just wanted to
insert the title next to the single char value. I will assume the second.

Somewhere on the far right of your sheet creat 2 columns with; say col AA
list all your single character values, and on col AB list what they
represent. Then on your, say A2 you will have the first character. Put this
on your B2. =vlookup($A2,$AA$2:$BB$50,2,0) then drag your formula down.
Modify the range to fit your list.

h.t.h
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Convert word into numbers and back 4
CONVERT NUMERICAL DIGIT IN TO WORDS (CURRENCY) 2
how do I convert an imported number to text 1
How can I have Excel determine what the last digit is in a series? 2
Extracting certain characters from a long string 4
how convert numbers to words 3
What type of "lookup" 3
Converting a cell value 4

Top