show alphabet instead of numbers

[ndmalam]

Hi.
I have a price list. I have a purchase rate colom. Want to creat a new coloum which will show purchae rate numbers as alphabet. For instance if purchase rate is 150, new colom should show "PFR".
I have a code assigned to every number. I.e 5=F . 8=D
please hep

[skywriter]

Maybe something like this.
Build your own map of numbers to letters.

[ndmalam]

Maybe something like this.
Build your own map of numbers to letters.

yes thisvisvexactlybwhst i need .How to do it. Please show it step by step

[ndmalam]

Maybe something like this.
Build your own map of numbers to letters.

yes this is exactly what i need .How to do it. Please show it step by step

[skywriter]

What's to show, there's numbers and letters and the formula is already there? Change the letters to your letters.

[ndmalam]

What's to show, there's numbers and letters and the formula is already there? Change the letters to your letters.

this is very old thread ,I never noticed the issue. I discovered a problem in this Formula ,it only works for 3 Digits.
I have data which include 1 to 5 digits in cell . how to alter this Formula to Work in for my Needs.
Best regards

[Pete_UK]

You should really start your own thread, rather than trying to tag on to someone else's, which is contrary to Forum Rule #04.

Pete

[ndmalam]

You should really start your own thread, rather than trying to tag on to someone else's, which is contrary to Forum Rule #04.

Pete

this is my own thread

[Pete_UK]

I'm sorry - I didn't notice that.

Can you attach a sample workbook which shows the variations in your data? Just follow the details in the first yellow banner at the top of the screen.

Pete

[josephteh]

Use nested SUBSTITUTE function:

Please Login or Register  to view this content.

[ndmalam]

Use nested SUBSTITUTE function:

Please Login or Register  to view this content.

Ok; it works
Thanks Dear.