letters

Can you do a Count down a column where the first three letters of the cells contents start with "DLE"?

I have this table of the range B2:J6 And I am looking for a way to randomly distribute the letters A-I across. These are the rules: 1. A row can take just A or A and A . If 2 As, then they should be immediately adjacent each other. Example B2C2. 2. The first four letters can appear more...

Hi everyone, Ok So Cell B2 contains a code that is "Numbers Letters Numbers" for example "12A6" or "1AR17" there can be many number or just one and many letters or just 1, but always in the same order. I need a formula to remove the Letters so I get "A" or "AR" please help if you can...

Hello I work with postcodes in various formats ie SE7 7AB or SE7; M20 1AB or M20 etc I would like to retrieve letters from the left appearing before first number. In the above it would be SE or M. Any suggestions?

Hi everyone !! I have been working on a macro to evaluate the contents of multiple cells in a spreadsheet and fill in the missing letters of the alphabet with "0". In short, I need to complete the contents of the cell to show 7 characters which will be either seven "0", the letters A to G, or a...

Hi there, I realise it has been asked before but I could not wrap my head around how to average out letters for a marks book. My spreadsheet is for athletics and each grade cell is reliant on an IF function eg. =IF(C2<15,"A",IF(C2<17,"B",IF(C2<21,"C",IF(C2>21,"D")))). I am hoping that I can...

Hi, Can someone help me with a formula to get this subset of letters: 1 2 3 4 5 6 7 A x x x x x B...

Hey guys quick question could not seem to find online. I have variable letters for example BN and would like a formula that would subtract that value by one so it displays BM. Any suggestions would be much appreciative.:):)

hello, generate all the formations of the 3 letters in the following criterion = no more than 5 letters for each of the 3 lines a = 01 02 03 04 05 06 07 08 09 1 0 b = 11 12 13 14 15 16 17 18 19 20 c = 21 22 23 24 25 26 27 28 29 30 31 So the formations will have 7 letters the maximum...

I use this to drag down alphabetical letters: =CHAR(CODE(A1)+1) It works, but only up to Z! What do I use to continue the sequence through to double letters like this: AA AB AC AD Thanks for your help!

hello please help dear helpfull friends i need a macro code to delete some letters with a code. for example i want to delete "a, r, ş, ö, ğ, o" in a excel document. i want a code that i can change letters , they can be less or more than these. so i will write letters that i want to delete and...

Hello, Greetings! May I ask for your assistance to help me get the data and remove all those after the numbers (symbol, letters, space, or any character). Ex: <tbody> Data Result +911111111 / abc@gmail.com +911111111 +911111111abc@gmail.com +911111111 +88888 abc@gmail.com +88888...

Got a file from another company. It is showing two coordinates for each cell. It has numbers across the top rather than letters. Has anyone ever seen this before? Is there any way to convert to normal Excel?

I hope you can see the image on the link/attached. http://tinypic.com/r/atn28i/9 On the image it shows on the left hand side of the black separator is a blank manifest, the information on this sheet (which will be on worksheet 1) will always be the same. These are different countries I send...

Hey guyz, I need to ask you for some help. I downloaded a UserForm named "AlphabetForm" and inside it is a textbox named "TextBox1". When I will type inside that textbox it will automatically take me to the target.row by matching the values in Column A with that of TextBox1. However, I need this...

Is there a formula I can use which will extract the numbers only from the middle of a string? The string currently looks like this; I need to be able to extract the '3837' part - this will always be in between 2 letters. The number of letters before may change, but the number after will not...

Hello, I have a list of column letters that need to have 2 more columns added to the current column letters. It isn't as simple as going 2 columns away and grabbing that from my list because the column letters are in random order. The letter G below is in my cell CJ10, HB in CJ11, etc.... I...

UserForm adds data to my worksheet TextBox13 is “City” TextBox14 is “State” If a user inputs lowercase letters into the TextBox13, can the target cell be formatted to UpperCase the first letter? And, if lowercase letters are entered into TextBox14, how can the target cell be formatted to all...

Iwant the "Name" field in my table to contain only capital letters. How to do it?

Hi everyone, I'm using Excel version 2016. I have a spreadsheet with 7,517 rows of data in column B. I currently have this formula for finding "EMP" in the text: =TRIM(IF(ISNUMBER(FIND("-",MID(B2,FIND("EMP",B2),10))),SUBSTITUTE(MID(B2,FIND("EMP",B2),10),"-",""),MID(B2,FIND("EMP",B2),10))) I...