Convert a Letter into a Word?

[robgolf]

I would like to take letters that I have in column D of my spreadsheet and convert them into words based on the text value I have assigned to that letter.

Ex: If I typed "Z" into a cell it would convert it automatically into the word "Los Angeles" etc.

Thanks so much guys!!!

-Rob

 

[Norie]

Rob

How have you 'assigned' the letters to words?

Do you have some sort of table?

 

[T. Valko]

I would like to take letters that I have in column D of my spreadsheet and convert them into words based on the text value I have assigned to that letter.

Ex: If I typed "Z" into a cell it would convert it automatically into the word "Los Angeles" etc.

Thanks so much guys!!!

-Rob

Same technique as used in your other post:

http://contextures.com/xlFunctions02.html

 

[robgolf]

Rob

How have you 'assigned' the letters to words?

Do you have some sort of table?

No, I have not assigned letters to words. Is that what I need to do? If so how would I go about doing that.

Thanks for your help!