# Convert Numbers To Letters. A=1, B=2 Etc

Feb 15, 2007How do I give letters a value in Excel? i.e. How can I make A = 1

How do I give letters a value in Excel? i.e. How can I make A = 1

ADVERTISEMENT

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

In row G, I have a wide range of values from -3000 up to 2500.

These values are generated from a formula. =A5-B5.

I need a script that will scan row G between G5:G500 and give them a letter value.

Convert anything less than 0 to an A

Convert anything equal to 0 or equal to 1 to a B

Convert anything between 2 and 7 to a C

Convert anything greater than 7 to a D

It can place the new categorized letter value over the original formula in row G or put the letter value right next to it in H.

First my goal is to sum a row and column. For example i want the sum of row 1 a to row 1 g. However, I'm using a loop for an automated macro. So i want to be able to say something like cells(1, count), so during the loop count goes from 1 to 7 representing the letters in the alphabet. But I'm not sure how to do so.

Secound, in my vba script to pull information from specific pages i say "sheet1.activate" how can i had the sheet switching during the process to speed up the calculation? and last but not least,

If Cells(1, locd) = "2008" Then

When i run my script, i get a runtime error 1004 application-defined or object defined error. The weird thing is, i can move what line it is on and then the macro will run ONCE and then it breaks again with the same error for that specific piece of code.

My store uses a retail price "code" wherein a price like 99 in expressed as a

code like "PP"--exchanging the number digits 1-0 as letters.

Is there a function to do this automatically?

i have a list of 2000 fields which have the same format IE "AB10014"

I need to remove the "AB" from every field and leave the #.

Besides putting a space and running text to columns I'm not sure how.

I have a column of cells, some blank, some containing just numbers, some containing just letters, some containing numbers preceded by the the letter 'p'

E.g.

frt

34.2

36

p34.5

In the cells containing the number preceded by the 'p' - i would like to remove the 'p' leaving just the number, with all other cells remaining unchanged.

Using the following data

R10-12128

R11-12x12x8

R11-12x12x8

R1-12x12x8

R1-12x12x8

R12-12x12x8

R14-12x12x8

R16-12x12x8

R18-12x12x8

R2-12x12x8

I want it to sort like this:

R1-12x12x8

R1-12x12x8

R2-12x12x8

R10-12128

R11-12x12x8

R11-12x12x8

R12-12x12x8

R14-12x12x8

R16-12x12x8

R18-12x12x8

What is the formula to achieve this?

way to convert all symbols (ú á) to their equvilant letters (u a) I know that I can do this manualuy with Find replace but I was hoping there was some magic that I am missing.

Please note that the exapples are only 2 of the symbols I need to convert the sheet could contain all of the varieties of symbol.

I want to convert all the Arabic letters into English (ie. Translitertaion) Not translation. I have found the below sample code in google and I have just tested but it is not working

Const cyr = "123456789" 'the cyillic alphabet in order

Const lat = "abcdefghi" 'the latin alphabet in the same order

Function convertchar(inchar As String) As String

Location = InStr(cyr, inchar)

[Code]....

If I type any number in cell A1 and run the above convertcells, it is not converting to latin.

Nice to meet you all. I'd be grateful for any help I could get on this as I have tried it and I'm a bit stumped...

What I need to do is the following:

Convert a 4 digit number (e.g. 1234) in a single cell to a 4 letter string (e.g BCDE) and have the output appear in another cell.

The conversion should be as follows:

0=A

1=B

2=C

3=D

4=E

5=F

6=G

7=H

8=I

9=J

0=K

So, for example, 3678 in one cell should be converted to DGHI in the target cell.

I am making an IF function that calculates and converts units, for example kg to g and g to kg etc.

This is the formula I typed in

=IF(E6=kg, ((F6/D6)*G6/1000), ((F6/D6)*G6))

When I evaluate it I get the #NAME error. What do I need to change to make it work?

I have a spreadsheet wtih a number of rows that contain answers to different criertia in each column.

The row may therefore have cells that either have numbers or letters.

Column A will be the title of the row.

I want to write a function to find the average value of the numbers in any row with title 'x'.

So it would look down column A, and look for those called 'x', and then average all the numbers across all those rows.

I have tried to use =averageif, but I think the fact there are letters in the cells being assessed (which I just want to be ignored) creates an error.

Tallying entires from a PDF into excel. Such that

c=1000

d=15000

e=50000

f=100000

g=250000

h=500000

i=1000000

j=5000000

k=2500000

l=50000000

In a cell I would like to type =c+d+c for example and have it say 17,000 rather then me having to type in =1000+15000+1000.

I created this data worksheet with many tabs and multiple users. On the main tab, something weird has happened and I have no clue how it happened or how to fix it....

View 5 Replies View RelatedThis formula will add up the letters D,N,H with one value

Like =SUM(COUNTIF(B4:AZ4,{"D","N","H"}))*12 will =36

How can I add bN =17 bmN =19 bD=24

=SUM(COUNTIF(B4:AZ4,{"bN","bmN","bD"})) to add up to 60

I'm working on a function that will sum a row of cells containing letters and numbers. I am currently using :

=SUMPRODUCT((0&SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(B5:S5,"T",""),"TP",""),"TPE",""),"P",""))+0) as my base.

Right now the formula will work with T, TP, and P; however as soon as I type TPE I get #value.

Either way you get the point of what I am trying to do, however my cells can contain any one of the following combinations:

T,TP,TPE

P,PE,

E

In column A I have the following numbers

13710

14782H

9827

14782

14206B

a formula that looks at this range of cells and returns only the cells that have a letter at the end. The letter range goes A to M

I am a school teacher trying to adjust my tracking sheet to calculate pupils levels. I am looking for 2 potential formulas that will do the following.

1 - In cell AE I would like to generate a formula that will take the data entered in cells J:5, L:5, N:5, P:5, R:5, T:5, V:5, X:5, Z:5, AB:5 and AD:5 and give an average level.

2 - In cell AH is it possible to generate a formula that will calculate how many levels of progress the pupils are making - In other words I need Cell I to be calculated against cell J to see how much progress the pupils are making - for example if in cell I:5, a pupil is was given a 3a, and then in cell J:5 is given a 4b, they will have made 2 sub levels of progress. As well as this, can that progress then be averaged out across cells I:5, K:5, L:5, M:5, O:5, Q:5, S:5, U:5, W:5, Y:5, AA:5 and AC:5 to give an overall number of of levels of progress? An then..... can I colour co-ordinate the cell so that if the pupils are making 3 or more sub levels of progress it turns green, 2 sub levels orange and 1 sub level red?

Levels work like this

3c

3b

3a

4c

4b

4a

5c

5b

5a and so on

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?

View 4 Replies View RelatedHow do I do data validation/cell formatting so that only alphabetic characters can be entered and no numbers?

(We use the cell for First Name, Last Name, etc. and I don't want potential entries like Mr. 56565 55454 because the cells are formatted as text and allow alphabet and numbers.)

I tried =NOT(ISNUMBER(H6)) for Data Validation, but that didn't work.

??

VR/Lost

I have in cell A1 the number 2 and in cell A2 the letter m.I want to add these two cells in cell A3 so as to appear 2+m.So i type in cell A3 =A1+A2 but it appears error.Is there a way to do what i am asking?

View 3 Replies View RelatedHow to autofill numbers with letters in excel 2007. Eg. 74cm, 80cm so on....?

View 4 Replies View RelatedIs there any formula or macro which gives the result from numbers to letters..? say like; 2,471,803.40 is in number and I'm looking for the result as 'RUPEE TWO MILLION FOUR HUNDRED SEVENTY ONE THOUSAND EIGHT HUNDRED THREE AND FORTY PAISE ONLY'. Is it possible to create macro to get this type of result..?

View 9 Replies View RelatedWe are doing a database conversion and I have been tasked with converting all our old promotion codes to a new system. The long and the short of it is this:

I am trying to write an equation that will look at two cells (say A1 & B1) which when put together could be one of the following numbers (01,02,03,04,05,06,07,08,09,10,11,12) and translate them to a letter (A,B,C,D,E,F,G,H,J,K,M,N)

So 01=A, 02=B and so on...

I was trying to use if statements, but there are too many.

I have a list I want to sort containing both letters and numbers. Right now the regular sort sorts like this

ABC-1

ABC-11

ABC-12

ABC-2

I want it to sort like this and don't have a clue how to do it

ABC-1

ABC-2

ABC-11

ABC-12

I am using excel 2003

I have an excel sheet where the user enters a bunch of info. In one of the cells, they enter an "account code" - this is then used to SAVE AS the account code.

The problem... if they enter things into this cell that causes the filename to fail (eg: *, /), the code errors out. I can error handle this in VBA at the time of the save, but I would rather prevent them from entering anything that is not a letter or number in the first place.

how to make letter represent numbers what i am trying to do. i am trying to put a sheet together to make my life easyer. i am a lectuer and need to keep trake of studes progress how this is done is that over the year they are graded my Pass Merit Distinction in using offic 2007 (Excel)and i was to make it so that if i put in a P it will =6 points ,M=12 points and D=18 points and for the total points to for each student to come up on the side after the units if there a rule for this and how would i put the rule into the sheet ?

View 3 Replies View RelatedHow can I avoid letters in a cell (read only numbers)

A given string of some letters (from three to five, six) is followed by a single number (1-4). Then it ends, or is followed by another such combination, up to a maximum of, let's say, four.

Example:

xxxx1

yyy3yyyy1

xyzxx1yxz4xzx1

xxx2xxx2xxx2xxx2

What I would like to do is to divide a given chain of characters into the smallest chains which contain only letters and one number. To the examples given above, I'd like to receive the following sets:

xxxx1

yyy3 and yyyy1

xyzxx1 and yxz4 and xzx1

... and so on

Is it somehow possible to do it with simple functions? Or is VB necessary (which sadly I don't know)?

Copyrights 2005-15 www.BigResource.com, All rights reserved