text string

Hello all and thank you for your help. I've run into an issue in Excel, and I cannot seem to get any formulas to work. This may be beyond the capabilities of Excel, but here goes. I need to perform the following functions and return a single value: 1) Search a text string in a single cell to...

Hi. If someone can please give me some advice, that will be grand. D7:D16 say either "POUND", "PERCENTAGE", OR 'NUMBER'. E7:E16 say a number ranging between 0.01 and 10000000 I effectively want to code in VBA so that E7:E16 will be formatted corresponding to the adjacent text string. So, if...

Looking for a formula to start with below, and return the following. Basically multiplying 6*50, 5*100, 10*100, 12*50, and so on. Start with: <colgroup><col></colgroup><tbody> CS/6 BX/50 EA CS/5 BX/100 EA CS/10 BX/100 EA CS/12 BX/50 EA Returns: 300 500 1000 600 </tbody>

Hello, :confused: I would check a cell with 2 text rows: - each row length must be max 25 digits long - I need a warning or highlight or cell fill in case one row exceed the max length I have set the data validation to check max length, non considering the row Could someone help me? Thanks...

Hi Guys, I hope you are all well? I was just wondering if anyone can help me with the below question. I have 3 different customers each with their own label but the same information follows that label like below. Customer A red+550075110 red+660075110 red+550 red-550075110 red-660075110...

I have an worksheet where I need to find all the weights (in kilograms and grams), but I only want to find the numbers (as I will easily be able to tell if they're KG or G just by the value it returns). If it's kilos, then the value I'm looking for could have 1 or 2 digits, and if it's in grams...

hello...i'm using excel 2016 and I need the 1st word after the number sequence. How do I accomplish this? My text strings are as follows: 67478_06271_CHILLAXBLACK_ZG13096-06 67478_06271_OFFWEGO_ZG12711-04BOOTIEWI 67478_06271_RUBIE_ZG13574-15STRAPPYW 67478_06271_SPRAYPAINT_LACEDBOOTWITHPLAI...

Morning All, Happy Friday! So I am trying to create a macro that will use a pre determined string of text and then at 3 different points, insert the contents of 3 cells on the worksheet. So far I have the following but I have hit a wall. Sub Macro2() ' ' Macro2 Macro ' '...

I have a table of data, an extract of which looks like this: <tbody> Country Product Office Sales UK Shoes Leeds 100 UK Shoes Leeds 100 UK Shoes Leeds 150 UK Shoes London 200 UK Shoes London 340 UK Shoes London 560 UK Shoes Birmingham 800...

HELP. I am trying to find the right formula to pull out just a document number/serial number out of a string of text. EXAMPLE: Cell A3 Contains: "Refer to WSC.RPP.52-024 for marking requirements." I want to make a formula that will just return "WSC.RPP.52-024". It seems to be tricky...

Good Morning, I am attempting to count the number of Cells which contain a specific text string and fall within a date range. The formula I have right now is as follows: =IFERROR(COUNTIFS(C:C,"*&A385*",AP:AP,">=E385",AP:AP,"<=F385"),"ERROR") C:C contains the range with text in which I am...

Many thanks in advance for your time and help . . . I have a simple user form where the date of an office visit is entered (as mm/dd/yy in OVDateTextBox) and the difference between that date and today's date is calculated. I am trying to build in protection against user entry errors where a...

Trying to create a sheet for archery scores. If someone hits the Bullseye, it's marked as an "X" but recorded as 10 point. We need to keep the X's, but this will determine who was the highest score, but if there's a tied, then it's whoever have the most "x's". How can I Show on the Score...

Hi everybody, I am working on a problem for which I have been unable to find a good answer out on the web. I would like to pull nine-digit strings from a string of text that is not uniform in size, content, or data arrangement. The only constant is that the string is always nine digits long...

Hi What is a formula or way I can write to determine if this is a text string(any text) then do this. If not, if numeric value, do that?

I've got a rather sticky situation with a spreadsheet that is calculating sales commissions. 1) Within my spreadsheet, I have a tab (COGS List) that contains all of our inventory items (by item number), their cost, and their price (Columns A, B, and C respectively). 2) I have another tab that...

Hi, I'm fairly new to this forum. I would appreciate assistance on improving my formula that works similar to the "Find & Select" (Binoculars) tool in Excel. The formula partially works at present with some sub-strings, though with others does not display any or all the results that it should...

I have a listing of 2000 rows of which are Text. I have made all of the text (proper) but what I really require is that the first word to be in UPPER as this will make it easier to distinguish when viewing. I am using Excel 2013. Any help would be appreciated. James..

I am trying to search two different columns that contain text, and flag another column in the same row if one the keywords I am looking for is contained within the text of either of the two columns. If the text does contain a keyword, I want it to mark a column with an “X”, and if not, I want...

Hello there, semi-noob-code-developer here ! :nya: I have being searching for an option to extract specific numbers from a string, and so far I have been unable to find a suitable solution. I have this string format: (14.370) FY14 - 3Q US Marketing Progression I need to extract the...