letters

Hi All This is my first post as i have joined this fantastic Forum. I am looking for anyone to help me with a problem. I want to run a VBA Macro that will basically search a columns of names and check that each name has letters A(a) to Z(z) and possibly numbers aswell. So Bill Smith is...

So I'm trying to return what is basically a score by looking up an ID and matching it. I condensed two sheets to one table to draw what I need. The issue I thought I was having was that the ID numbers were preceded by letters to distinguish what type of ID. Example ABC 12345678. So I...

Howdy, Column A has name. In column B I have a formula that lists all the names that contain the letter / letters entered in cell D2. I need a VBA code to display my name in column B without having to press enter after each letter entered in D2. Eg. I write a letter - let's say - the letter a...

generate all 7-letter formations, maximum 3 letters repeated. ex = aaabcde ... bbbcccd, etc. we have 10 letters = abcdefghij to conbine the formations with 7 letters please!

I'm opening this thread on behalf of Danya Subramanian who sent me a PM: First, Danya, if you see this, it's preferred that you open a new thread if you have a new question. That way others can benefit from seeing the answer. Also, you can't receive PMs until you have a certain number of...

Hi, we are trying to find a macro which would replace the alphanumeric contents of each cell with: -letters with "L" -digits with "9" -any other remaining characters with "_" Example: <tbody> XC/73:54-15PC 44C becomes LL_99_99_99LL_99L </tbody> Best NEil

what is the formula to populate a column with alphanumeric string? the string is to be used as product code.. say, starting at LFK101 - LFK102 - LFK103 (increment) so on down.. the string can be any number of letters and numbers.. like A1, ABC123, XYZ110.... the letter is always at the left and...

Hi,, In column A I have very many phrases. Each phrase may or may not have one or more words in brackets. How can I make all the words in brackets written in capital letters? Thank you.

I have a formula field in an access table which basically combines 2 fields. However, the calculated field changes the number field to remove the zeros. Is the below possible? <tbody> Letters Numbers What the Calculated Field shows What I want the calculated field to show AA 0001 AA1 AA0001...

Hi All Scratching my head a bit with this one. I've code that loops through some cells and look for a certain sequence of letters and numbers and if found, copies it. The sequence used to just appear as the first 7 characters so I could just check for it there, however a recent change to...

Hello - I have been stuck on this formula for a few hours. It is the last one I need for this report. Here is mycurrent formula: =SUMPRODUCT((1/COUNTIF(CIF,CIF&""))*(--(LEFT(Officer,3)=D2))) CIF = my rangename for each customer’s ID, which consists of three letters and four numbers...

Hi Using Office Pro 2010 / Win 10 1803 I need to print a letter, A5 size, so putting x 2 onto A4 landscape, then cutting after printing. Is it possible to do this also using Mail Merge, so that each A5 letter has 'Dear [name]' etc, please? When I have tried before, only one of the two A5...

Greetings, It's been a few months and I'm still piecing together my dashboard. I'm getting closer! This might sound extremely basic but I cannot find examples online, or that I can identify as what I'm looking for, that does the following. I run a report for members that contains all kinds...

I have a spreadsheet which I am using vlookups. when I enter an item it will auto populate the product code into another cell. The content is also from a validated list, though has over 2000 products. is there a way of typing the start of a name to locate products that start with those letters?

Hello all, How do you make a cell or whole selected area/spreadsheet automatically capitalize any inserted text to CAPITAL letters? Thank you. Much appreciated in advance.

I copied a column of data and pasted it in another column, the letters are now red instead of black and it wont let me fix it. Does anyone know what is going on here!?

Hi guys, just wondering if someone help me with this issue. I need to differentiate between following. Anyword/Anyword with 124521/12453544 So Anyword can be anyword normally written Properfor example.. Auto/Huber GmbH And and with Numbers 1234/2356412 those can also be any...

Hi, FXD (Dept.014865) I would like to just have 014865. Please note: - I need a formula for about 15,000 rows - the only consistency is after the "." hence numbers and ) - I do not want the ) & FXD changes up to 10 letters Thank you kindly,

Good morning dear wizards. Can I please get some guidance on this dilemma? I want to run the code below ONLY on worksheets whose names DO NOT START with "ULT". Some tab names are all letters, numbers, or both letters and numbers. Is there a way to do that please? Sub UNprotect_All_Sheets()...

Hi, I'm looking for a macro that highlight specific words in cell (for example: update, cable, Premium) / words written all capital letters/ full sentences after the symbol ":" Any ideas? Thank You