letters

Hi, I thought about doing this in Excel but was curious if I could do this in Access. If I can then I'll work my way through each step to get it done. I am trying to get away from having to formate columns and rows and have everything presented to me in a nice neat look. We send letters out...

Hi, I'd like to create a string of 6 random consonants (e.g., "kftryp") but with 2 caveats: 1. no letter repeats (e.g., you can't have "kftryk") 2. the string does not contain a consonant that is used in another specified cell (e.g., if the specified cell - A1 - contains "tiger" then "kftryp"...

I have an Excel workbook with 12 sheets, and in each sheet there are several shapes (lets say rectangles). In each rectangle there is text in it(1234 Smith, 3452 Jones, etc). I've have a search button into which I enter the number, name or both and it should be found. The problem I'm bumping...

Hi, I am trying to remove duplicate letters from cells, however the code below works fine on letters but when there are numbers involved it doesn't end well. What I would like to do is remove all duplicate letters from a cell even if there are numbers present. Can someone help with this. Sub...

Greetings Folks, I'm probably not in the right area but I have an idea that will make my job and the job of my peers 100000x's easier. I was considering sitting down and redoing all the letters we send customers using UserForms or using Excel, somehow and googling until I figured out how to...

I am looking to get out from all cells the letters I made in buld out from this cell https://www.screencast.com/t/apAeD0FCrE6 <tbody> walgreens.com/store/c/as-seen-on-tv-roll-a-lotion-applicator/ID=prod6095201-product...

Hi Everybody. I have a list of names and last names for each letter of the alphabet, I would like just input a two letters in A1 for example, and the get the names and last names belong to this two input letters, the output would be good stating at B2. VBA code would be the best way for me to...

Hello all, I know I can use conditional formatting for each partial text string I want to effect by using SEARCH, but that would be a lot of single rules and time consuming to implement. I'm looking for a formula that will find any instance of a list of several partial text strings and apply...

Hello How to leave only letters (element symbols) in a range of cells. The range begins at E1. Each element (Ex. Al240 %) is one cell. Make this: <tbody> Al240% As189% B208% C165% Ca393% Co340% Cr267% Cu327% Fe249% Mn_Calc. Mo386% Nb400% Ni341% P177% Pb220% S180% Sb206% Si_Calc. Sn326%...

I have been using this function for some time to convert a column number to letters. It should take any number and return the correct letters, even double letters, e.g. AH etc. It works, but there is at least one number which causes it to fail - that number is 36. Here is the function: Public...

I have a range of vertical data in one column from E1:E1406 with cells containing 5-6 letters. I want to create a separate column next to it which would extract cells from E1:E1406 containing a certain word, in this case the word "FT" and populate the separate column automatically. I tried...

Say you have a for loop that posts stuff for each iteration into cells one below each other. That's pretty easy to do, with say "A" + i. How does one go about doing this with the cell letters, or in other words to put stuff into cells to the side using for loops? Cheers

Good Day I have excel column with format text which include data in letters , number or letters and number in addition to number of letters or digits are not fixed so what i need to remove this dot if it is start or end the data only as i tried to remove it through Ctrl+F then choose replace...

hello helpfull friends really i need a help Macro code i have a dictionary word list in column A. i want to write 4 or 5 different letter and find words possible from list to write with them . For example: i will write letters : O, U, T, O, K, B and the vba code will find words like: TO...

Hello. I am looking for a formula that will find specific letters in column B and sum the value located in column J of all the specific letters. Example: Letter Value A 1 B 2 C 3 D 4 E 5 =SUMIFS(J1:J5,B1:B5,"A",B1:B5,"C",B1:B5,"E")...

Hello, newbie here that is stumped! I am looking for a formula that would return the word in a string of words that has both numbers and letters combined into one word. eg..........in cell A1 - "Front Comp 02 Stn Mh20A Fixture 13" would return in B1 - "Mh20A" (the only word with #'s and...

Calculate the 7 letters in each of the 4 quadrants, In the draw line. Each quadrant is represented by a color The middle column is in x (lilac), we also have the list Of the sums of the letters of the 4 quadrants. Objective = see that each letter has 3 possible patterns = 0,1,2...

Hello Guys, Can anyone help me on this please. I have my excel data sheet and my word document as per link below https://www.dropbox.com/s/my62tw9jsfktwo9/fixedcharge16032018.xls?dl=0 https://www.dropbox.com/s/h5wb91ymd39h3tr/mailmargeflo1.docx?dl=0 My word document is already...

My spreadsheet consists of: column A: single numbers or letters from 1-10 and a-j column B: first-name sp last-name. (Abe Lincoln, George Washington, etc) column f: single numbers or letters column g: return last name only. how can I combine both following formulas to yield the last name only...

I am trying to do a similar function to a vlookup but the data is not a value. For example, i am looking for a ID of a customer that is all letters and want to return column 5, can someone assist w/ that function i should be using?