substring

Hello Excelperts, I find myself in a bit of a conundrum and looking for your help and expertise to learn how to pull a substring from a cell of variable length string. From the transcript column A1, I have variable length transcript string, what I am looking to extract is the name of the...

Please can anyone help? I would like to hide PIVOT row entries featuring a specific substring as part of the text string for that entry. By using the following code, I can specify the name of a full entry to be hidden: With ActiveSheet.PivotTables("PivotTable1").PivotFields("SPECIFIED FIELD")...

Hi all, Background: I was searching for a formula (for conditional formatting) that checks if a specific cell (text format) contains a specific text of an adjunctive cell as a substring. If there is no match, the cells should be highlighted red. As an example: <tbody> 01 ABC_01_XXX 22...

Hi, I am trying to come up with an easy way in Excel 2010 to search column F for data that should not be there. Column F contains a string of data which contains a number. This number refers to the Job that has been undertaken, for Example A3 - 1G 123456 Data String. I know that the number...

I have around 180 records that have an 80 character string where one row (H1 *) contains an account number the next row (R12*) that contains detail that needs to be separated into different columns on another worksheet. I can use a MID function to extract but I think it would be more efficient...

I have a spreadsheet in which column D always contains substrings of "women's", "women" or "womens" for women's clothing, or "men's", "men" or "mens" for men's clothing. Based on whether the substring is women's or men's, users enter a whole number value in column I, <= 20000 for women's and <=...

I could really use some help with a formula... it needs to return the number directly following substring "RX" within a string? For example if i have the string "12354165RX15" then just show "15". Another example is "165163546RX15_G_B" then it would still need to also just show "15". I have...

Hello all, I've been trying to figure this out for a little while and thought that I would just ask for some help. My data looks like the following: A1= 1/5/2015 A2= 2/6/2015 A3= 3/7/2015 B1= Playground A / School A (Project 123) B2= Playground B (Project 91); Playground C (Project 8)...

Hi I have data in following format: two columns A and B containing only text. A is a short list comprising just a few hundred text strings. B is much longer list containing several thousand rows and has text strings that are extended versions of text in column A. each value in Column A could...

Hello guys, Hope you are doing well. I am seeking your help regarding an Excel formula. I will be receiving a large text with a lot of XML tags in A1 cell. I will have only a couple of XML tags that I will be using, the rest will be useless. The purpose would be to extract the text between...

This is all fairly new to me, so be gentle. I'm using Attachmate Reflection for Unix and OpenVMS, which is capable of using VBA to automate interactions with a host of other applications. I'm trying to put together a macro to run from Reflection which will result in an orderly spreadsheet list...

Hi, I’ve been lurking here for years now – so thanks for all the help! I’m currently validating customer address information in our system, and I’ve run into an obstacle checking for proper street abbreviations. I’ve been using this formula at present (probably lifted from an older post on...

Hello Experts. I just started learning about VBA and got below problem. In below example, column A is a huge set of cells that has strings with URLs in it. I need to extract only URL starting from "http" keyword. There are no cases when this string has more than one URL. I searched internet...

Hey I have a long url and I need only the root domain in the url for example: http://blablabla/2009/11/35-vintage-t-shirts.html------>http://blablabla/ http://lalalala/calendar-past2.html-------------------->http://lalalala/ http://bobobob/calendar-past2.html------------------>http://bobobob/...

Hello. I have been trying to develop a simple code in Excel 2007 that creates a pop-up message when any cell within a range (i.e. D13:D25) contains the substring "ggg". I have tried to do this indirectly with a formula in another cell i.e. G13 (=IF(ISERROR(SEARCH("g100",D13,1) ),"", 1) and...

Hello: I have some data shown below in a spreadsheet. <colgroup><col span="2"><col><col></colgroup><tbody> g z g s r b* h c n u* e r </tbody> Each string (g, z, u*, b*...) is in its own cell. I am trying to highlight the cells that has *. I tried Conditional Formatting...

I'm trying to dynamic align column B to column A, but by matching a substring, and not by matching the whole content of the cell. I have two column, with filenames in each (all with the same format, basically: Show.name.SxxExx.optional.title.source.codec-group.extention), but they might be a...

Have my emails populating into Excel and need assistance pulling a substring (8 digit number) out of the string placing in column F, then equipment into G. I think I need loop maybe? Excel WorkbookABCDEFGHIJ1**********28/26/2011 12:57Tender - FCL - SAN ANGELO, TX - 09/01 04:00Anheuser-Busch...

Hi Everyone, First of all, you guys are all awesome. I've learned a lot just from searching other stuff. I do some computational biophysics research but am having trouble with some of the data processing because I need bits of information that are nestled inside large strings of text. Here's...

I need a formula that will look in a cell and give me a certain substring of whatever data is in there. I'd like to write, =Substring(Left(A1,8,2)), meaning start at the far left of cell A1, move over 8 "spaces", and give me whatever is in the 8th and 9th space. Of course, I can't write it...