Free Microsoft Excel 2013 Quick Reference

assigning numbers to letters

I have a word, for example ROCK. I asigned numbers to the word. R=1,O=2,C=3,K=4.
My Question: If I type in ROC it must return 123. If I type in KR it must return 41, etc. Is there a basic formula I can use to solve this?

Hope to hear from someone soon.


Post your answer or comment

comments powered by Disqus
Hello All,

I've been staring at my screen trying to fix this for quite some time. Mabye a fresh look by others will help. I have a script which allows the person running the macro to select a cell, and the idea is that the the column letter is printed in a designated cell (which will not user defineable, but that's not important now.)
Untill now I'm working with a function provided by microsoft to convert numbers to letters. This script works on it's own, the script I use for extracting the column number aswell, but when put together, I get no output in the designated cell.
The code is posted here, I hope somebody can help me out, I feel like I've tried everything.

greetings,

Peter


	VB:
	
 GetUserRange() 
    Dim UserRange As Range 
    Dim ColNum As Integer 
    Dim Output As Variant 
     
    Output = ConvertToLetter(ColNum) 
    Prompt = "Select a cell for the output." 
    Title = "Select a cell" 
     
    On Error Resume Next 
    Set UserRange = Application.InputBox( _ 
    Prompt:=Prompt, _ 
    Title:=Title, _ 
    Default:=ActiveCell.Address, _ 
    Type:=8) 
     
    ColNum = ActiveCell.Range("A1").Column 
     
    If UserRange Is Nothing Then 
        MsgBox "Canceled." 
    Else 
        ActiveCell.FormulaR1C1 = Output 
    End If 
End Sub 
 
Function ConvertToLetter(iCol As Integer) As String 
    Dim iAlpha As Integer 
    Dim iRemainder As Integer 
    iAlpha = Int(iCol / 27) 
    iRemainder = iCol - (iAlpha * 26) 
    If iAlpha > 0 Then 
        ConvertToLetter = Chr(iAlpha + 64) 
    End If 
    If iRemainder > 0 Then 
        ConvertToLetter = ConvertToLetter & Chr(iRemainder + 64) 
    End If 
End Function 

If you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines


I have an excel spreadsheet filled with numbers (i.e. a 10x10 excel sheet grid) and want to convert the numbers to letters. I want to map from 1-26 all the letters of the English alphabet. So 1=A, 2=B, 3=C, ...26=Z. I am a novice with excel and I know how to do some basic SUM formulas, but that is about it. Can someone point me in the right direction on how to convert this sheet or how to create a macro that can convert this sheet for me? I saw other posts that talk about converting letter grades to numbers then taking the average, etc, but I need to do the opposite. Any help? I am attaching a spreadsheet as an example that I am trying to convert from numbers to letters...

Thanks,
---MC

Can someone please tell what the correct formula to use to convert numbers to letters as in the following?

Examples:
A1 = 123.4
converted to = ABC.d

B2 = 987.6
converted to = IHG.f

Lookup Table 1
1 | A
2 | B
3 | C
4 | D
5 | E
6 | F
7 | G
8 | H
9 | I

Lookup Table 2
.1 | a
.2 | b
.3 | c
.4 | d
.5 | e
.6 | f
.7 | g
.8 | h
.9 | i

how do i change the column headings from numbers to letters in excel?

how do i change column designators from numbers to letters in excel

I have just changed to excel 2007 - cant find the r1c1 tab to change the
column heading from numbers to letters - can anyone help

assign numbers to sales invoice in exccel 2002 and move the invoice to a data
base for reference. numbers assigned should start from number 1 to 999

I'm looking for a way to assign values to letters so I can average columns but retain the letters in the column. I've been able to successfully overwrite my letters with appropriate values and subsequently avg, but that's not what I'm looking to do.

I've attached a sample of what I'm trying to accomplish. I'm looking to keep a running average of each column on the right where D=1, P=2, and M=3.

Sidenote: File isn't as diabolical as it may seem Trying to put something together for employees to keep their own running tab of accomplishments so they are actually prepared for reviews.

Edit: Fixed attachment.

i want to convert numbers to letters in the excel Sheet
I.E: when the number is 1000.00$ it write in another cell
on thousand dollar only

1500.00$ one thousand five hundred dollar only

I have a chart with the alpabet in the first column in the next four columns are numbers that correspond to the letters in the 1st column. How can I use MS Word to reference my chart and convert these numbers to letter and vise versa. Also since I have 4 seperate columns of numbers. I need to be able to specify which column of numbers I want to be used to deciper my alphbet. Does anyone have any ideas on the best way to do this? Basically it is making 4 seperate decoder wheels/rings but just automated so it will decipher what is typed in Word (alpha or numeric). Thanks for you help.

Dear Mr. Excel,

I'm new to this forum.

I have been trying to assign a number value to each of 3 letter characters but have not found the correct function. Can you help?

Ultimately, one of these 3 letters will be typed into each cell within 1 column and the 3 corresponding numbers will be used in a formula to calculate the product of a second cell multiplied by this number to appear in a 3rd cell.

Any help will be appreciated. I have tried using 'VALUE' but I keep getting an error. Thank you.

offsup

Hi Guys, like so many new Excel users I am in the process of trying to learn how to program with VBA.

I am trying to figure out how to convert any whole number to a letter string.

A=1 B=2 .... Z=26 etc AA=27.

I would like to extend the process to accept any whole number. e.g 1000, 50,000, 1,000000 etc....

Is there a standard algorithm for the conversion ? I can then try to write the code for this.

Thanks

Megazoid

I am trying to find a formula that will convert existing number combinations
into corresponding letter combinations in Excel. The relationship of numbers
to letters is as follows:
1 = A 6 = F
2 = B 7 = G
3 = C 8 = H
4 = D 9 = I
5 = E 0 = J

For example, I'd like to convert a cell that contains '1250' to 'ABEJ'

I've had no success with the HELP feature in Excel.

Thank you for any help you may provide
Jason

Hi,

Here’s the situation.

In Excel I have:

1st column: Thousands of store numbers.
2nd column: I manually created something called “Master Corp ID”

The Problem:
1st Column has approx. 29,500 store numbers but they’re all not unique. Some
stores can have the same store number because they’re all the same type of
store… i.e Circuit City, Best Buy, also, not all Circuit, Best Buy will not
have the same unique number due to type of store it is/area and et cetera.
In-addition, I also have a ton of mom and pop shops with their unique store
numbers.

What I Need Please:
I need a way to in column 2 to automatically assign numbers for each group
of store numbers so for example:

Store Number Master --- Corp ID
2205 1
2205 1
2205 1
2205 1
3566 2
4523 3
5545 4
5545 4
6001 5
6001 5
6001 5

Can someone please help me?

On my excell spread sheet, the top formula bar that used to have letters, now
has numbers. How do I change these back to letters?

I have a range of numbers representing a culmalative total for a population
e.g:

1 500
2 750
3 1000

I then generate a sequence of random numbers, e.g 250, 800 etc. So if I get
250 it should appear beside 1 (since it is less than 500), and if I get 800
it should appear beside 1000 ((since it is less than 1000). Anyway to do this?

I have no problem with a solution that reads the random numbers generated
and then assigns them to the correct position

In my session of excell, the collumn headings as well as the rows are numbers
(in stead of letters).
How can I change the numbers to letters again?

I'm using Office 2003. Excel column labels used to be letters A-B-C etc, but
somehow got changed so both rows & columns have number labels. I would like
to go back to letters for column names, but haven't been able to find out how
to make the switch.

On my excell spread sheet, the top formula bar that used to have letters, now
has numbers. How do I change these back to letters?

I have a list of consecutive dates in row 3:3.

In column J I will enter dates.

I would like a formula that takes the date I have entered in column J (eg.
J9) and searches row three for the matching date and then returns the value
in row 4 in the same column.

For a similar problem I used a combination of INDIRECT and MATCH.

=INDIRECT((MATCH(I9,3:3,0))&"4")

the problem is that match returns a numerical position instead of a column
letter. is there any way to convert a number to a coresponding letter? or
just a formula that will do what i want?

I'm using Office 2003. Excel column labels used to be letters A-B-C etc, but
somehow got changed so both rows & columns have number labels. I would like
to go back to letters for column names, but haven't been able to find out how
to make the switch.

Hi,

I need a function to change numbers into letters for coding purposes.
We use a coding system in the office for our prices.
Example: 1=A 2=B 3=C 4=D 5=E 6=F 7=G 8=H 9=I First 0=J Second 0=K
In this case if I have a price 15000 it will be coded as ADJKJ
Is there any function or macro that can code my numbers automatically.

Thanks

I have to convert my number scores to letter scores.

example of ranges: 300 to 400 = A. Is there anyway I can enter all my
ranges for letter grades a, b, c, d, f and the program will return a letter
grade.

I looked in convert and if statements, but couldn't really find it.

Thank you Cindy

Hi,

Here’s the situation.

In Excel I have:

1st column: Thousands of store numbers.
2nd column: I manually created something called “Master Corp ID”

The Problem:
1st Column has approx. 29,500 store numbers but they’re all not unique. Some
stores can have the same store number because they’re all the same type of
store… i.e Circuit City, Best Buy, also, not all Circuit, Best Buy will not
have the same unique number due to type of store it is/area and et cetera.
In-addition, I also have a ton of mom and pop shops with their unique store
numbers.

What I Need Please:
I need a way to in column 2 to automatically assign numbers for each group
of store numbers so for example:

Store Number Master --- Corp ID
2205 1
2205 1
2205 1
2205 1
3566 2
4523 3
5545 4
5545 4
6001 5
6001 5
6001 5

Can someone please help me?


No luck finding an answer? You could always try Google.