strings

I have two cells in excel. They are exactly the same. (TN28 01\1 & TN28 01\1) (I have just got them from two different spreadsheets). I have used EXACT function, IF function to compare the strings in the cells. I have also used Text function to convert these cells to text and then used EXACT and...

Sorry if the title isn't descriptive I honestly had no clue how to quickly say what I'm working on.Hello, thanks very much in advanced for the help. Basically I have a long list with two columns, the first column has a word and the second a string of numbers. I would like to automatically...

Hello - I need to search a cell for two strings. If either of the two strings is found insert "YES" in the formula cell; if not, insert "No". Example: If "WRITE" or "RW" is found in column A, insert "YES" in column B, else insert "No" Column A Column B...

Please see cut-out of my screen. Why is "B " not found in "B "? The code InStr(Left(comment_original, 2), "B ") returns 1 for a lot of strings similar to the one that is being examined here, in my sheet. https://drive.google.com/file/d/0B3thvJXzChxmWl9SS2RHN0p5U1k/view?usp=sharing Thanks in...

Is there a macro or module out there that would parse agent strings? Just looking for Device Type, Operating System, Browser. For example: Mozilla/5.0 (iPad; CPU OS 9_3_5 like Mac OS X) AppleWebKit/601.1.46 (KHTML, like Gecko) Version/9.0 Mobile/13G36 Safari/601.1 Tablet, iOS 9.3.5, Safari...

Hi I have 15 strings that I need to add together to obtain a part number. Is there a nice way of doing this rather than string1 & string2 & string3 ... etc Steve

I have a column of text strings which some contain the ˜ ™ € Â and/or â symbols. I though using the Chr function within VBA would work but it doesn;t seem to. Can anyone help with what I need to do replace these characters/symbols from the text strings? TIA

Hi guys , Im strugling with string that have same meaning but different spelling , here is a sample string1: MFK Ruzomberok string2: Ruzomberok I need to figure out a way to count the number of different letters , I guess difference in these two strings should be 4 , but anyone know I ninja...

Hi, Hope somebody can help me with a formula :) I would like to search through text to find certain ID numbers. For example: CSAZ11871Z YA6200046Z YA7300232Z YW0600782S DAIC03798Y The strings I look for always contain 10 characters and always have both numbers and letters in them. FYI...

I want to search column C on for a specific string. The cells in column C can hold variable length strings such as C1: AAB1, C2: AB1, B1, C1 C3: D2, E3 etc. I want to find the first instance of a specific string and then copy cells around it. The problem I have is that, the use search doesn't...

I need to add leading zeros before two separate strings for all in column E. For example: <colgroup><col width="111"></colgroup><tbody> 0336565-CM </tbody> <colgroup><col></colgroup><tbody> 336700 </tbody>

I have data in cells that are number values and string values. The String values are #_ # with the # being any number. Example: <tbody> 3 2 1_4 3 4 2_10 </tbody> I want to SUM (3,1,4) and (2,3,2) Here is what I have (Using Ctrl+Shift+Enter): =SUMPRODUCT((LEFT(IF(ISTEXT(L31:L38)...

Hi, In a set of code, I have several variables tied to arrays. Ex: - Color1 = Array(23,42,45) - Color2 = Array(43,23,67) Separately, I would like to enable others to choose between Color1 and Color2 if they want to, but not have to mess with any code and not have to select the color every...

Is there anyway to make Excel interpret 'A*' as 'an A followed by a star' rather than 'any string beginning with an A'? Thanks in advance. I apologise if this has already been asked. I've searched but didn't find anything. If you are wondering why I want to know... I am a teacher in the UK...

I have product codes: (they are in C column of active sheet) DO-001 DO-002 DO-003 DO-004 And I have big list of data: (they are in C column of "Sheet1") 41300100_DO-001_14215171 41300104_DO-001_14215173 K1_ISK_41300661_DO-002_13190369 NP_41533258_DO-003_14910884 DO-003_DD_44_ddd And I want to...

Hi there, I would like to know if there is a way to combine two strings together into one cell. I am talking about putting numbers together, there is a set of Account#which are on different lines and they are displayed like |Account#:12542-|5651256|" The pipe (|) is there to show the column...

I'm not entirely sure if that name is the most understandable. Oh, well. This falls in the same general vein as the last question I asked (which has been answered, and I am quite thankful for that), but plays out in reverse. I'll use a similar example situation for consistency. Now, say that I...

So, this question is rather similar to the one I've asked before. Let's say that I have a variable called "Nickname" within a UserForm that I would like to have the same value as that of another variable whose name can be built up from different captions in the UserForm. This other variable is...

Hi everyone, Im facing some issues with the find/search function. I have a example matrix <!--StartFragment--> <colgroup><col width="87" style="width:65pt"> </colgroup><tbody> 21650094-6 21650065-7 23730130-7 21436620-7 21724110-3 22852562-6 5792980-4...

Excel Friends: I have list of strings in one Column, i.e. Column A, with a variable number of rows. Also, I have a Table of two columns filled with strings in each cell, let’s say Column C, and D, with a variable number of rows. The idea of the VBA macro that I would like to get help is this...