Troubleshoot:Convert a column of numbers into Alphabet characters Error

Convert a column of numbers into Alphabet characters

Hello All,
I would prefer to use functions if possible.
I need to converts a column of numbers in to alphabetical characters.
In each cell there are numbers ranging from 0 to 999 999.

I want to replace each number 1 with A, 2 with B, C with 3.....9 with I and 0 with J.
Eg: in cell A1 the number 233450 convert to BCCDEJ.

I have tried using Replace, Choose and the concatenate, they work partially.

Thank you for your help.
Max

Keys to the Problem Convert a column of numbers into Alphabet characters

Download SmartPCFixer to Fix It (Free)

I think you will need a UDF to do what you want...

Function NumAlpha(S As String) As String
  Dim x As Long
  NumAlpha = Replace(S, 0, "J")
  For x = 1 To 9
    NumAlpha = Replace(NumAlpha, x, Chr(64 + x))
  Next
End Function

If you are new to UDFs, press ALT+F11 to go into the VB editor, click Insert/Module on its menu bar and then copy/paste the above function into the code window that opened up.
That's it.
Go back to your worksheet and use NumAlpha just like a built-in function...

=NumAlpha(A1)

If you failed to fix it, another option is to call Microsoft and walk through the process with a technician. To do this, dial "1-800-936-5700". Explain the error that you received and the steps in the update process during which it was displayed. The technician will be able to walk through the steps from getting a new product key to finishing the installation.

Recommended Method to Fix the Problem: Convert a column of numbers into Alphabet characters:

How to Fix Convert a column of numbers into Alphabet characters with SmartPCFixer?

1. Download SmartPCFixer. Install it on your computer.

2. After the scan is done, you can see the errors and problems which need to be fixed.

3. The Repair part is done, the speed of your computer will be much higher than before and the errors have been fixed. You can also use other functions in SmartPCFixer. Like dll downloading, junk file cleaning and print spooler error repair.


Related: Can Not Install Update KB2509553 On OS Win XP.....many Times Attempted,Can We Have Multiple Users Using The Same Excel 2007 Template When They Login To A Terminal Server ?,Can Or Will The Dell Dock Harm My Computer?,Can't Connect To A Wireless Network With A Wireless Laptop,Can't Establish DDE Connection To Excel Starter 2010 From Word Starter 2010,Changing The Default In The Access Find And Replace Box,Charts In Excel - Show All Months,Cant Find Graphics Card After Reinstall Windows 7,Changing Sheet Names In Multiple Graphs Using VBA,Changing A Single Row Of Data Into Multiple Columns,Computer Not Starting In Any Mode - Normal Or Safe,Conditionally Change Backcolor Of Cell Depending On Date,Computer Said Operating System Corrupt And Shut Down, Now Will Not Start At All,Computer Freezes When Idle And I Have To Reboot,Computer Starts Up Slowly
Read More: Troubleshoot:Cookies: Receive message that cookies need to be enabled Error,Tech Support: Control panel showing up blank,Fast Solution to Error: convert 32 bit CD to 64 bit so my computer will recognize it.,How to Fix Problem - Conversion of date format using a formula?,Solution to Problem: Continuous Loop of ''Windows Explorer Has Stopped Working'',Changing Outgoing Mail Port Number to "587" as required to use Comcast E-Mail,Check box for sign off,Computer freezes when saving picture,Computer randomly freezes and restarts.,Computer won't wake from sleep with Windows 7 sp1 installed
[PR]
by Fat32FileSystem33 | 2016-09-23 17:30