alphabet

Hello all, i want to extract data in a selected range of cells based on condition. If the 9th character is an alphabet, then the rest of the characters(from 10th) in the cell to be copied to the adjacent cell. If it is not an alphabet then from 9th character in the cell to be copied to the...

Hello Team, Could someone advise me how I can filter only cells which starts from alphabet V345 T039 0231 M444 0311 Q001 I would like to see only which starts from alphabet. Please advise me

I have an excel template (Productivity Tracker), where we have to put specific request number based on various task. For e.g. for task MDC Account Creation, request number should start with "A" follow by seven digits(numbers) ex A9827366, total length 8. So, for each different unique task I have...

I have a column with a lot of data. I select the column/range. How can I generate a list starting in cell c1 with all unique items from the column. (Preferably in alphabet order)

I am sorting a list of client names. One of the companies' names starts with AAA. For some reason, when I sort the range by alphabet, this name ends up at the end of the list (under names starting with Z). Why is this? Is there any way to fix it? Note, it is not an option to change the name to...

Hello all, This is one of my first posts, so please let me know if I'm not doing it correctly! I read the forum manual but still, I am human and I make mistakes.. My previous post was approved so I hope this one will be as well. So here it goes.. I have a userform which can copy specified...

How can I restrict cells to allow only alphabet character entry only? I cannot figure out a possible formula in Data Validation and formatting the cells to General or Text allows other non-alphabet characters. Thanks in advance.

Hello, Step1 - I am looking some Formula or VBA which can look B9 value (it can be alphabets "A To Z" or could be Number "1 to 9") in this example B9 value is "2", I want look this value "2" into C7 (most right alphabet or number 2 not found) look into D7 (most right alphabet or number 2 not...

Hello Folks, I want to delete few words in A2 cell of all the sheets in my WB. Please go through the 4 strings and their expected results. I want to keep the last numeric value of the string and if the string contains Alphabet as last word it should keep both numeric value and alphabet also.The...

Hello I am fairly new to formula in Excel Is is possible to use the MID function to find out if say character 6 is a letter (A,B,C etc) or a numeral (1,2,3,4 etc) in the example below the letter could be any of the 26 letters of the alphabet and numbers could be any 0 - 9 12516VBRAKAK...

Hi, Q1: I have the following simplified chart (note: row can change so want to be able to do the totals at the last row). Total line want to make sure no decimals, bolded the entire Total row) Q2: If want to add in column G that will return value % with 1 decimal which take column F $ divided...

In long texts, I need to find acrostics. I know how to break up lines. I use the following (in column B) to get only the first letters of each line: =LEFT(A1,LEN(A1)-LEN(A1)+1) Now how do I automatically check if there are consecutive letters (alphabetic order) in column B?

Hello, I have a spreadsheet of 7 columns (A-G) and can have varying amounts of rows (in the 1000's). The first column is a list of client names "LASTNAME, FIRSTNAME." Each employee has a caseload assignment based on the last name of the clients. So one employee has all the "C's" and another has...

For example, let's say I have a range of cells from A1:A20. That range has a drop-down list data validation already applied to it. Now, I know that it is possible to have a "Custom" data validation. I wanted to limit the characters that can be written in that range to only alphabets. I have a...

Hello, Using 1-26 with the corresponding letter of the alphabet I would like to be able to total the sum of letters from lists of words. so using 1-26 with A to Z a = 1 b = 2 c = 3 d = 4 ..... Example: the word cat = 3+1+20 = 24 dog = 4+15+7 = 26 would appreciate any assistance. best...