characters

Hello, I have a few columns (not adjacent to each other) where I expect users to enter valid e-mail addresses. What I would like to validate is that the entry contains all the valid characters possible, namely digits 0-9, latin letters a-z (not case sensitive) and special characters...

I have a spreadsheet of store numbers that I need to change around. The first 3 characters are always ABC, and then it follows with 2-4 digits. I need to make these all 4 digits, with the missing characters being made 0. So for example ABC1234 would stay as is, ABC123 would become ABC0123, and...

Hi friends, I need big help on the following. I have two columns with texts. Column A has the old text and Column B has the new text. I need to match these two and show in a 3rd column the additional characters (highlighted in red color) in B column compared to A column text. Further in D...

Hello, people, Wow. This forum sure makes it difficult to show a sample spreadsheet. And I've read posts complaining, but that rule apparently ain't gonna' change. Ah, well. OK. I've done a lengthy search, found many people with the same problem, but no answers. How, in Excel 2007, to...

i have a doubt how to extract only characters from a set of word using only excel ex john17son1992born premkumar12from560077 king0295of99theking how to get output as johnsonborn premkumarfrom kingoftheking please clear my doubt

Morning, I am looking for a code which will show a msgbox to advise me the character count in the active cell is anything but 17 Some info for you. Worksheet is called MC LIST The code will only need to work for column B The range would be B6 & down the page Example, So i type in cell B9 15...

I am stuck trying to do a sumifs where a partial match = set criteria <tbody> Price Group Country Volume A <100 - 499 GB 1790 B 500 - 1000 GB 5232 C 1001 - 2000 DE 9958 C 1001 - 2000 GB 4556 </tbody> so If i want to sum the volume where price group >= 500 I'm thinking along the lines...

Hi I have lots of strings of data in column A, first cell being A2 However, they end all in "~p~" followed by a number I want excel to find ~p~ and return the characters after it. I have tried a few formulas =right, left, mid, find etc but can't figure it out. Thanks in advance Gemma

Have a table in a sheet that is connected with info on sharepoint. Wondering if there is a way to remove the last 5 characters (.xslx, .docx, .xlsm etc.) from an entire column. Any ideas?

Hi, I have some code which works fine, but I now want to add some coding to utilise the Text to Columns function. I need column B to be fixed width of 5 characters and the data format to be set as 'Date' (UK date though not US). Please can someone help? Cheers Chris

Hello, I'm looking to extract product numbers to do some analysis. I get them in a format that is this: /product/12345/product-description The part I need is the "12345" (the product number). Sometimes the products are displayed like: /product/12345?product-description or /product/12345 The...

I have thousands of records that have User IDs in them. I need to find a way to delete these User IDs, as the data is being sent externally. The issues that I'm encountering are: - The text is not static. It always starts with UID, but the last 4 characters can be alpha-numeric variables. -...

<tbody> A 7 Count A characters in a cell As a given number Like ( A - As - 7 ) B 6 To return the like of 14 for A-A or 13 for A-B C 5 so A- B- C in 3 cell add up to 18 and so on D 4 E 3 F 2 G 1 </tbody>

Hello Excel expert people! I have a string "165 / 168 / 170 / 172 / 68" that is present in a number of cells throughout my worksheet. Dependant on certain criteria, my aim is to format the text so one or more of either 165, 168, 170, 172 or 68 within those cells are formatted with...

Can someone help me with a formula; I’d like to run a Vlookup For values in column J against a column in another sheet. If nothing is found then Vlookup only using the first 7 characters in column J to a column in another sheet and only it’s first 7 characters. thanks,

I need to take a date (currently formatted as 07/25/2019) and make a new column into text with 8 characters. 07252019 Ideas?

Hi Excel master, I've been struggling to figure this out and so I am requesting you help to write formulas based on this particular value: For example: CMR_01_28988699_0 Questions: 1. Formula for counting the number of characters after the underscrore after R? 2. Formula for counting the...

I need to extract the number to the left of the "/" Data Example - B4: Innsbruck, University Hospital, (ads, peds), CIC 271, G. Gastl, D. Nachbaur (79 (82) 41/38) Desired result = 41 The number could be 1 to 3 characters, but any method of getting closer would help. I found an example on the...

Need some help here, guys. Not a VBA pro, and I have tried my best to amend it but just couldn't solve it. I have 2 worksheets in my XLSM. Worksheet 1 is Taylor. Worksheet 2 is Overall. I want to rename Taylor worksheet based on a dynamic value enter in Overall worksheet cell E6 and append...

Hey everyone, Does anyone know how to use illegal characters in a Drop down? I have looked it up, but everything I have read went over my head. I have a a drop down that is dependent on a drop down. In the first drop down I have a few fractions that need to be options. Thanks for the help.