letters

I have the following 8A, 20C, 110J. I want a formula to remove the letters from the far right, so that it returns 8, 20, 110. Letters can only be from A-Z. I think it's a pretty simple formula but my brain is making me think of something more complicated. Would like to avoid using any helper...

Is it possible to ensure a user can only type into a cell two letters say “ks” followed by four numbers . So if a user forgets either the letters or four numbers he will be prompted.

Hi Apologies if the title seems a little hazy. I am trying to create a macro that will search for all my product codes starting with Z but have other combinations of letters after it, new ones are added but I am not necessarily informed of this. I need the macro to keep all the Z codes and...

I have a text in an Excel worksheet that contains "1a" and "3b" and i want to change the letters to uppercase with out changing the rest of the text case Cheers Clive

I have a data set of 100k rows and i need to count the codes (including numbers and letters) of 1 column. The problem is that the model is all linked - and i will keep adding raw data on the sheet, so i am trying to find a formula i can drag down - help would be much appreciated

each Cell in Col AB contains either no data, numbers or letters, not both Starting Cell AB19 I need to clear letters only leaving numbers to remain

Hi, How can I get that RED sum. <tbody> A=10 B=10 C=10 d=5 D=20 AC=10 A A 7 B 4 C 5 ----> 40 3 d A 4 AC 5 5 ----> 40 6 6 d d 2 D 2 ----> 30 C 1 C B 3 d D ----> 45 </tbody><colgroup><col...

Hi i have the code below where it does a search but it will only let me enter numbers in the textbox and not letters, but i want to be able to input both numbers and letters can you help please, i am very new to VBA and still learning, i have searched for the answer alot on internet with no...

<colgroup><col></colgroup><tbody> =MATCH(BC$5,INDIRECT("A"&SUM(BB$15:BB15)+1&":$A$10000"),0) This formula works when finding skips between numbers. Is there a formula for finding skips between letters? </tbody>

I am trying to create a random text generator but I need the following chances assigned to the following letters. C = 20%, I = 70% and P = 10%. These variables will change with each new block but if I can get help on the first part I will know what to do. I do know that I could use the...

In column A I have a long list of times but they all have the letters PM at the end. Is their a formula I could write in column B that would get rid of all the PM? eg in column A: 7:45PM 10:30PM I just want (in column B): 7:30 10:30 Thanks in advance

Hello, I like to copy row based on multiple conditions and I hacve a problem with letters. I like to check if cell in column O contains letters P and R, and if so, copy row to next sheet. my code is (with not working P and R) Dim cell1 As RangeDim lastRow1 As Long, i As Long lastRow1 =...

Hello I need the letters cut off on the end of these cells. The letters vary from 1-2 characters and there is no space after the number. Some numbers are also decimals. 1ML - 1 450G - 450 120ML - 120 1.5ML - 1.5

Hi all,I am trying to program something in VBA. The inputs are matrices which varies on the amount of stocks, which is unfortunately not the same all the time.I already managed to get VBA to calculate 4 constants (A, B, C, D) with the matrices as input, there will always be only 4 constants, but...

I'm interested in a macro that removes an entire row if the cell in column "A' contains "II", and the II needs to be case sensitive to capital letters. Also if the macro could ignore the first row which is headings. Thanks for your help, greatly appreciated.

- Within a userform, I have a textbox in which applicants type their last name - Some last names contain multiple capital letters (e.g. "McDonald") - The Proper Case function only capitalizes the first letter of each name and forces the remainder as lower case Question - Is there a way to...

Hello everyone! I need to create a formula that will allow me to make a list in the following sequence: PC8101A PC8101B PC8101C PC8101D PC8101E Then repeating all the way to PC8100E Is there a macro I can use for such? The first two letters will never change, the last is always a single...

Hi All I hope there is an easy way of doing this as I have 30,000 cells I need to extract some information from. In a cell I have some information extracted from an invoice. For example BG12CF942RU, BG15CF96EFDI the information isnt consistent except for one part. Somewhere in the cells will...

Hello, I use the following VBA to make everything all capitol letters. I am trying to find out how to change this to apply to all the other data that is already in the worksheet? Thanks for all help. Private Sub Worksheet_Change(ByVal Target As Range) Dim cell As Range On Error...

I am used to creating form letters in Word. But at my new job I was sent an Excel spreadsheet and I want to create another just like it. The first sheet is where names, addresses, and other data is entered. That data automatically populates the form letters that are the other sheets of the...