Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  Advanced Search
  HOME    TRACKER    Excel


Advertisements:










Add A Letter Before An Existing Number In A Cell


I WANT TO INSERT A LETTER IN FRONT OF A NUMBERS THAT ALREADY EXIST IN CELLS
IN A COLUMN. SORT OF LIKE USING "FIND & REPLACE" EXCEPT THAT I DON'T HAVE
ANYTHING TO REPLACE; I JUST WANT TO INSERT A LETTER PREFIX IN FRONT OF
NUMBERS.


View Complete Thread with Replies

Sponsored Links:

Related Forum Messages:
Data Validation Format Letter Number Letter Number Etc.
I want to apply Data Validation to a cell, so that only the following combination of letters and numbers can be entered.

Letter Letter Number Number Number Number Number Number Letter.
e.g AB123456C.

View Replies!   View Related
Number Of Letter In A Cell
I have a list of names and I need to know how many names are greater than 6 characters in length. What is the formula I need to enter?

View Replies!   View Related
Give Cell Number After Letter With Function.
I want the A4 cell contains the calculation of B4 (but the number gained from the funtion row and if the B1 cell contains the number 10 the K(B1)=K10

[A4]=B(row())*K(B1)

View Replies!   View Related
Insert A Letter Or A Number In Front Of Numbers In A Cell
Need a function that would insert a letter or a number in front of numbers in a cell for example

column A
3245

I want to insert the prefix "S" in front of the nummbers 3245. so i would hopefully end up with

Column A
S3245

View Replies!   View Related
Fill Down But Have Column Letter In Formula Change And Not Cell Number
i want to fill down a column and instead of my formula changing from A6 to A7 i want it to change to B6.

View Replies!   View Related
Return Column Letter Based On The Letter In A Cell.
For the below formula is it possible to replace the B's (column location) with a cell Say Z146 which contains the letter B (or a number if thats easier and someone can tell me the numbers for each column).

When the formula is dragged into the next cell (down) it takes its column reference from Z147 and then my life becomes so much easier.

=IF(INDEX('Overs-Unders'!B:B,MATCH($C145,'Overs-Unders'!$A:$A,0))"",INDEX('Overs-Unders'!B:B,MATCH($C145,'Overs-Unders'!$A:$A,0)),"")

View Replies!   View Related
Cell Format: Input The Number With The Letter "A" At The End
I have a Col where the cells have been formatted to enter "PR" before the numbers input into any cell in that Col. I did this by using the custom selection in the format cell. However some times i need to input the number with the letter "A" at the end. For instance PR123456A.

Now in some cells it lets me do this but in others it does not. It would end up with 123456A, loosing the PR at the front. I have checked that all is well within the custom window. Can any body offer an explanation as to why it could be doing this.

View Replies!   View Related
Add Decimal Point To Existing Number
I need to add a decimal point to a column of numbers. For example, where it says 126 needs to be changed to 1.26, 3035 changed to 30.35, 13593 to 135.93 and so on. Can this be done automatically or with a formula?

View Replies!   View Related
Macro To Copy Existing Workbook X Number Of Times
Just curios if this is the most efficient way to copy a workbook x number of times.
I tried copying 77 workbooks and not sure exactly how long it took, but about 2 mintues. The original workbook is 300 KB.

View Replies!   View Related
Convert Letter To Number
Is there simple function that anyone knows of (or has written) that will convert a letter to its alpha-numeric equivalent?

For instance, A = 1, B = 2, AA = 27, etc (a = 1, b = 2, aa = 27)

View Replies!   View Related
Name Cells With Same Letter But Different Number?
Is there any way to name cells with same letter but different number?

e.g i need to name the first row A1 to A100.

View Replies!   View Related
Way To Get The Column Letter, Instead Of Number?
Is there a way to get the column Letter, instead of Number?

like in A1 Column() would equal 1 in B1 Column() would equal 2

I would like

in A1 Column() to equal A and in B1 Column() to equal B

View Replies!   View Related
Number Of Occurrences Of Each Letter
I need to figure out the number of occurrance of a letter in a word written in a cell. For Example i am writing "pattern" in a Excel cell. I want to know the marco/vba code that will give me the number of occurrance of each letter. The output should be:

p=1
a=1
t=2
e=1
r=1
n=1

View Replies!   View Related
Column Letter Instead Of Number
is there a way to make the following code return the letter of the column instead of the number? currently if the 'String' value that is in 'ColumnFind' is in column B this code returns a value of 2. i Need the 'B' for later code to work.

ColumnLetter = ColumnFind.Column

View Replies!   View Related
Column() To Return A Letter Instead Of A Number
Can column() return a letter instead of a number? I am planning to use it with INDIRECT? Is that possible?

=INDIRECT(row() & column())?

View Replies!   View Related
Convert Column Letter To Number
Some bits of code I have learned use column numbers and some bits use column letters.

Can someone share a line or two that I could add to my macro that will convert the F representing column F into a 6, and vice versa, so that I can continue using my pre-existing bits?

View Replies!   View Related
Column() - Give Letter Instead Of Number?
When using the formula '=COLUMN()' in cell A1, it returns the number of the column - in this case, '1' (for column A). Is it possible to affect this formula so that it returns the column letter (in this case, 'A')?


View Replies!   View Related
Knowing The Worksheet Number Or Letter
Without using VBA code, is there a way to display or find the worksheet number of the active worksheet you are viewing? All my sheets have names, and I have a lot of them.

When I want to loop through a set of them with code, I want to know what numbers they are beforehand.

View Replies!   View Related
Convert Column Number To Letter
I can obtain the columns numbers but I cannot get the letters. Is there anyway to convert from a number to a letter?

eg. somefunction(1) gives me column(A) as an answer?

View Replies!   View Related
Exchange A Number For A Letter Forumla
I have a sheet which calculates payment amounts.

Column titles:
Hours | Rate of Pay | Total

In the hours column usually the entries consist of numbers and everything works fine. However when an employee is on holiday they are still paid.

What I want to do is be able to enter the letter "H" for one of the entries in the hours column. The sheet to translate this as 2 hours.

H=2 x rate of pay = total

I cannot for the life of me get the correct formula to in order to achieve this. I don't particularly want to use a macro for this and others have suggested the "COUNTIF" function.

View Replies!   View Related
Sorting Number/letter Combos
I have a spreadsheet with information in columns a-x. In column A there are part numbers like: RH630-34, PH630-343, 6-255, 16-01, 72500, There are may combinations of just numbers, and numbers first letters second, and letter first number second.
All usually seperated by a hyphen. The entire spreadsheet will be sorted by Column A first.

I need to sort them so the order would be numbers first and combo with number letters next. finish product: 6-255, 16-01, 72500, PH630-343, RH630-34. Is this possible? I have seen other posts and suggesting putting spaces before the numbers. That seems to work but in the case of 6-138 and 6-1038 the 6-1038 is first

View Replies!   View Related
Check If Character Is A Letter Or A Number
I have a cell range that is passed as a String to a function, and within that function I need to extract only the Column letter. If it was just 1 letter it would be simple, but it may be 2, so does anybody know of a way of testing to see if the second character is a letter or a number?

View Replies!   View Related
Using .Column After An .Offset - Need The Letter But Get A Number
ce.Offset(, 4) = "=" & ce.Offset(, -1).Address & "*" & ce.Offset(, 4).Column & "25"

If X29 were equal to ce.Offset(,4) then the value in that cell should be set to

"=S29*X25"

Currenctly it is returning "=S29*2425"

(FYI - ce is just a variable to capture a particular range/cell that is dynamic and used within a For Next Loop)

View Replies!   View Related
Return Column Number Not Letter
How to return column number (not letter)?

View Replies!   View Related
Look At Column For 3 Letter 3 Number Combos And Move
have thousands of rows and the cells look similiar to this:

FAKE NAME PARTNERS FTA048

some other combos could be FTB039 or BCL048 ETC

whats the best way of looking down a column
and moving any 3 letter 3 number combos to another column

so that FAKE NAME PARTNERS and FTA048 are in seperate columns

View Replies!   View Related
How To Output Column Letter (not Number) With A Formula
Is there a function that will output the column letter? For example there's one I know of: =COLUMN(), which outputs column number, but not the letter. And if not, can a formula be written to output it without converting the spreadsheet to R1C1 style or using the lookup function that refers to a separate table within the spreadsheet?

View Replies!   View Related
How To Find Any Number Greater Then (x) And Replace With A Letter
how I could search for any number great then (x) and replace it a letter

For example I have an excel table with a series of weights.

lbs
6001
4560
6789
2000
5656
8879
1243

I like to replace any number greater or equal to 6001 lbs with the letters SS.

Example:

lbs
SS
4560
SS
2000
5656
SS
1243

Then I'd like do the same thing again but this time replace any number less
then or equal to 6000 lbs with the letters SS-LL .

Example

lbs
SS
SS-LL
SS
SS-LL
SS-LL
SS
SS-LL

View Replies!   View Related
IF THEN Statements: Assign A Letter Grade To A Number
I have figured out how to assign a letter grade to a number, but am having trouble assigning it the other way, a number to a letter grade. For instance: If a student gets an A, I want the column next to it to indicate that the A represents a 4; a B represents a 3; a C represents a 2; D a 1; and F a 0. This will allow an easy grade point average calculation.

A 4 History
C 2 Math
A 4 English
B 3 Physical Ed
D 1 Science

GPA 2.80

View Replies!   View Related
Convert Column Number To Letter From A Range Objec
Is there an easy way (without writing my own conversion function) to get the column letter from a range object, as opposed to the column number?

View Replies!   View Related
Find And Replace A Specific Letter/number Combination
I have a column of references I wish to standardize. Contained within a general text description there is also an order-specific reference number, which is not relevant for my purposes. I wish to find all of these numbers and replace them with nothing (i.e. retain the rest of the description).

The reference numbers are always in the format "P#####/##". Unfortunately these references are in the middle of the text field, not at the start or end, so I can't use a LEFT or RIGHT formula to delete them.

Once these reference numbers have been deleted I will then be able to filter for unique records only. When I do this at the moment the filtering has no effect due to these specific reference numbers.

View Replies!   View Related
Return Number Based On Letter Position In Alphabet
i wish to number the cells bases on the cell on the right.

Heading
A
A
A
A
A
A Total
B
B
B
B
B Total
C
C
C Total
D
D
D
D Total

to

Heading
1A
1A
1A
1A
1A
1A Total
2B
2B
2B
2B
2B Total
3C
3C
3C Total
4D
4D
4D
4D Total

The values in place of A,B...can range between 1 to 6.

View Replies!   View Related
How To Insert Leading Zeroes Into Mixed Letter Number Field
I have a column of data that is given to me that is a mix of letters and numbers and I need the numbers to have leading zeros, they must all be three digits. The data has either 3, 4, or 5 letters followed by numbers 1 through 999. Example: ABCD7 I need to change it to ABCD007. I am using Excel 2004 for the Mac.

View Replies!   View Related
Reference Text File To Import Using Generic Letter Or Number
I have recorded some script in excel to import a *.dat file, delete the first 19 rows of data, then export the data as a *.csv file.

My problem is I have circa 30 *.dat files to import, all of which have large file names and I am fed up with copying and pasting them in.

So my question is, in the below code, can I somehow use a reference at the start such as:

abc1.dat = "1"
abc2.dat = "2"

Then where the files were used, reference the "1".dat and its exported version "1".csv for the abc1.dat case.

View Replies!   View Related
IF Formula: Assign A Specific Letter To Each Rating, Depending Of The Obtained Number
I have some delivery ratings from suppliers, and I want to assign a specific letter to each rating, depending of the obtained number. Criteria is:.........

View Replies!   View Related
Array Mode That Put It Back In The Letter, Number Display For Formulas/functions
My excel (2003) is stuck in array mode - is there any way to get it out of Array Mode and put it back in the letter:number display for formulas/functions? It's doing this in VBA too which is totally killing me.

View Replies!   View Related
Convert Lower Letter To Capital Letter Automatically
When I type a single lower case letter into a cell, what formula or conditional formatting should I use to always convert it to a capital letter automatically?

View Replies!   View Related
How Color The Cell When The Existing Data Is Altered
How color the cell autmatically when the existing data is altered. the same needs to be done with the entired column

View Replies!   View Related
Pulling A Letter From A Cell And Filling Another Cell With Info
Here is what I am trying to do with no luck so far.

If I type RS23U1R109000 in a cell A1, I want B1 to read the 5th letter or
number and fill B1 with E86.

Example
A1= RS23U1R109000 B1=E86
A1= RS23V1R109000 B1=E87
A1= RS23R1R109000 B1=E84

As you can see in my example, the 5th letter could be U,V,R or whatever, but
I need cell B1 to read that letter and populate B1 with E86, E87, E84 or
whatever.

View Replies!   View Related
Add Time & Date In Current Cell Without Losing Existing Data
Trying to create a macro that will add the date & time & initials (i.e 8/26/09 2:34 PM JOD) into the current cell.

I've found plenty of macro's that will do this but it ends up deleting any existing text within the cell. I need to be able to add it in the middle of a text string.


View Replies!   View Related
Add New Data To Existing Cell Based On Multiple Selective Inputs?
I have a spreadsheet of courses required to reach a certification. On this spreadsheet I have listed the number of hours required for each course in one column, and how many hours I have accrued in an adjoining column. Not all the hours will occur at once, so I tend to bound from cell to cell adding hours in small amounts. What I am trying to do is create a macro that will allow me to add to the existing number of hours to the newly accrued hours, without typing over what is already there.

For example…Class 1 requires five hours total, and I have two hours accrued. If I accrue two more hours (for a total of four hours) I want to update cell E2 without going in to this cell manually and changing this number. I would like to enter the additional two hours in a text box or similar function, and have that function update E2. To add to the level of difficulty, there are four levels of class. This means not only do I need to be able to select which class hours need updated, but which level of class. I have attached the spreadsheet I am working with to try to make things a little clearer.

View Replies!   View Related
Check If End Of Cell Is A Certain Letter
I need to check if a cell ends with {"a","b","c","d","e","S","t","v"}. and if it doesn't diplay a warning

this is what i have

--------C
10----4444s

=IF(RIGHT(C10,1)={"a","b","c","d","e","s","t","v"},"GOOD", "Must enter Suffix Letter")

View Replies!   View Related
Populating Cell With A Letter
I have a colum with 350 cells in use, each of these cells contain a 3 digit number. Without having to go into each cell and type is there a way i can put the Letter
"R" infront of each of the 3 digit numbers?

View Replies!   View Related
Lookup First Letter In Cell...
Is there a way to lookup the first letter of a word in the cell. I am trying to keep my sheet as small as possible for emailing. It would help to narrow down the possible lookup combinations. For example I only need to know if it starts with T, P, or V. I don't need to know the rest of the word. eg TMO, TAEFA, P1284, VTL3D etc.

View Replies!   View Related
Check If Cell Contains Letter
I need an excel cell formula that will detect whether or not the word in a cell contains the letter 'R' or not.

ie. If cell A1 contains a word that contains the letter 'R' then return a '1' otherwise return a '0'.

View Replies!   View Related
Check If End Of Cell Is A Certain Letter And Match With Other Cell
I have two cells where data is input in the form

1234A the suffix letters can be a,b,c,d,e,t,s,v

I need to check if the suffix letter from both cells match up...

a can only match a
b can only match b
c can only match c
d can only match d
e can only match e
a-e can match t
s can only match s
v can only match v

is this possible without any macros?

View Replies!   View Related
Reverse Letter Sorting In A Cell
I have specific need for text manipulating formula. Is it possible to reverse text in a cell, for example: microsoft excel to lecxe tfosorcim.

View Replies!   View Related
Add Cells With Letter & Numbers In The Cell
I'am trying to add a row of cell that contain a letter befor the number
I need to add-up the numbers and ignore the letter


View Replies!   View Related
Cell Column Letter In Formula
I want to put the letter A in cell a1(or any cell in column A, SHEET1) of SHEET 1 and get the information from SHEET 2, column A. Put this information in column B sheet 1. I will have about 40 columns in sheet 2. I used a if formula, but only 8 ifs can be used.

View Replies!   View Related
Correct/Incorrect If Cell Contains Letter
I have one column: in the first cell comes text (beginning either with the letter "L" or "R") and afterwards, in the next cell, comes a number (either "7" or "8"). Basically the column is made up of alternating cells containing either text (code of a movie) or numbers (responses to the respective movies). I want to find a formula which writes either:

- "correct" if the number "7" follows a cell containing the letter "L" or an "8" follows a cell containing the letter "R";

or

- "incorrect" if the number "7" follows a cell starting with the letter "R" or the number "8" follows a cell starting with the letter "L".

Basically the 8 is always correct with an R and the 7 with an L: ...

View Replies!   View Related
Check If A Cell Value Starts With A Letter
I have a workbook and I want to check in a cell, if the value in the cell starts with "S" or "D". In VB.net there is a method .StartsWith to check the starting letter in a file. Is there a way to check the starting letter in the cell?

View Replies!   View Related
Copyright © 2005-08 www.BigResource.com, All rights reserved