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.

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.

- Converting column numbers to letters (and a little more)
- Convert Number To Letter
- Converting decimal numbers to letters
- How do i change the column headings from numbers to letters in ex
- Change column designators from numbers to letters in excel
- How do i change the column headings from numbers to letters
- Assign number to sales invoice
- Assign Value to Letters for Averaging
- How to convert numbers to letters
- Converting numbers to letters
- Assign values to letters
- Convert whole numbers to Letters
- How to convert numbers to corresponding letters? Ex: 123 to abc
- Assign number to groups of same numbers
- How do I chang numbers to letters on Excell forumal bar?
- Assign number to correct range
- How to change collumn heading numbers into letters?
- How do I change column labels from numbers to letters?
- How do I chang numbers to letters on Excell forumal bar?
- Convert number to letters
- How do I change column labels from numbers to letters?
- Coding numbers to letters
- Changing score from number to letter grade
- Assign number to groups of same numbers

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 FunctionIf you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines

Thanks,

---MC

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

column heading from numbers to letters - can anyone help

base for reference. numbers assigned should start from number 1 to 999

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.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'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

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

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

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?

has numbers. How do I change these back to letters?

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 stead of letters).

How can I change the numbers to letters again?

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.

has numbers. How do I change these back to letters?

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?

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.

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

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

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.