-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
sub string
-
A
Comparing two columns for identical sub-strings with a mixture of numbers and text
I am looking to compare two columns A & B and find if there are any sub-strings that are the same & Infill column C either with the same text or 1 if it matches - whichever is easier <tbody> Col A Col B Col C Alt Col C R5 201F35 030` 020` 712 0 0 R6 NFL1006235` 1001 1001 1001 1...- armchairandy
- Thread
- column compare 2 columns find same sub-string formula sub string
- Replies: 4
- Forum: Excel Questions
-
A
VBA to extract string after specific character using loop
Hi I have a real simple VBA to right , but as I am really new to VBA I am very much struggling, though I understand the logic completely I just dont know how to write it in VBA. Can someone please help? Problem follow: A1: Mr Adam Smith & Mrs Celia Smith A3: Mr A Ping & Mr Wa Chu A5: Dr I...- asgsitting
- Thread
- macro string sub string vba
- Replies: 6
- Forum: Excel Questions
-
F
Search Substring within column of text strings and list all results
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...- fchiav
- Thread
- list all matches search sub string text string
- Replies: 5
- Forum: Excel Questions
