strings

Can someone help please? I have a list of boxes containing strings of text, I need to highlight any words appearing in these strings if they appear in my list... is this possible? For example: <tbody> Sentence List My motorbike is yellow yellow My car is red red car...

Hi I have a workbook with two columns A & B. Each cell in Column A contains delimited strings: Example A1 contains OT6, PA3, PU4, PR2, PL8 A2 contains: AP3, AP, AP4, AP10 I would like to compare these cells in column A to a list in column B and return the answer if any of the values in A1 or...

I have 36k records of various free form text strings in one column. Is it possible to do a COUNT on the number of combinations? If some words are misspelt is there a way to do a fuzzy logic search and COUNT?

Hi VBAers, I have a range which is selected via a find function, not a cell reference. The find looks for two unique strings then selects the range between. From here I want the selected range to expand out 12 columns, say from Column A to Column M and keep that range selected. I can't...

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, I need some help with an userform, i`m fairly new to vba coding so bear with me :). I have a "ComboBox1" created in the userform, i`ve used the "row source" property to alow a user to select only four strings from a range in excel. My question is: Can i use an if statement to force the...

I have a list of text which all end in "Config File", each of these text strings vary in length. I wish to be able to delete the words "Config File" from each of these text strings, and after i have deleted the text then add the text "V2A" to each of the text strings. Is it possible to do this...

Hi there I have an excel spread sheet containing a table like so: <tbody> Find Replace AAA.BBBB.CCCC.00001 AAA.BBBB.CCCC.00001 AAA.DDDD.EEEE.000001 AAA.BBBB.CCCC.000001 </tbody> where A, B, C, D, E represent any letter, and 00001/000001 represent any number. The strings will always be...

(please dont delete this thread, i cant think of a better title) hi everyone, i have strings (each cell contains) like this: <style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>WW098-ZK-TRXF-PAB-MRX-01 <style...

Hi Peoples - plz - Conditional formatting of column (text) data req: - if A1 = A2 then A2 is same fill colour as A1... strings down data column... & if A1 <> A2 then A2 is different colour to A1... strings down data column... Seems highly useful for quick visual reference change of similar...

Hello! I have recorded a macro to find an exact string and replace it to a different format. However, I have different strings and in the macro I would have to put in all the different variations in order for the macro to work. Is there another way I can change various strings to a certain...

hy accidentally found that excel considers this two strings !!i AAA as equal when (un)protecting a sheet can someone explain me why? is it just in my pc? could it be some sort of virus? thanks

I will probably be here a few times over the next few weeks to get answers to the stuff I am learning. Function REMOVE(Txt as string) As string Why 2 As Strings?

Hi everyone, I am a beginner when it comes to VBA programming. I only know basic functions and know how to record a macro. I need your help to facilitate me a task. I am trying to extract specific information from many word documents and put them in a common excel table. I attached a sample...

Hi, I have data exported from PowerApps/MS Flow into a excel spreadsheet and I need to extract the specific strings from the data to paste into Word. Sample strings: <tbody> [{"Id":2,"Value":"Unix/Linux"},{"Id":3,"Value":"VPSX"}] </tbody> <tbody>...

Hi, I wrote the formula below and it partially works. I was expecting 3 strings to return, but I am only receiving 2 strings. Syntactically, the formula is correct. I confirmed that the underlying data is correct. I narrowed the error down to the when the Match function leads into the row...

Hi, can anyone help me with the below: I have delimiter separated strings in column A A value in column B Two separate strings in two reference cells (C1 and D1) I need to sum the values in column b where the string in column A contains first C1 then D1 I've so far tried...

I'm trying to create a UD function that returns the region of the world of a two-letter country code but there must be a limit on strings. See my rlist Any ideas how to go about this differently? or can you join two strings? Public Function getregion(ctry As String) Application.Volatile Dim...

Hello, I am completely green when it comes to making my own functions. Could someone tell me what I'm doing wrong here? I am sorry I was not able to find a relevant previous post...

I have a large odd CSV export that has too many columns to open without error. I need to replace about a thousand strings in the file. I ran a crude macro that extracted all the strings I need to find and replace. So I not have a one column listing the old strings and a new column listing the...