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.

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
--
If u change the way u look @ things, the things u look at change.


"Mike of Book Worm Angels" wrote:

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.