Hi
I have a 2 Column excel file. 1st column is just the Serial Number in increments of 1. Every cell in 2nd column has Text ending with a square bracket, e.g. ] Sometimes a sentence ends with a number enclosed between two closing square brackets e.g. ]12]
I am looking for help for a VBA Macro that goes through each cell in Column 2 and searches for the occurrence of the following BEFORE the FIRST square bracket.
Even if there are two macros for bullet 1 and bullet 2, that would work.
I have a 2 Column excel file. 1st column is just the Serial Number in increments of 1. Every cell in 2nd column has Text ending with a square bracket, e.g. ] Sometimes a sentence ends with a number enclosed between two closing square brackets e.g. ]12]
I am looking for help for a VBA Macro that goes through each cell in Column 2 and searches for the occurrence of the following BEFORE the FIRST square bracket.
- Any digit: So if there is a cell with the entry, Hello2 How are you]23] then the corresponding serial number from Col 1 should be outputted in a new column. If '2' wasn't there after 'Hello' then the search should not single the serial # out.
- Search for any character occurring together more than once e.g. My name is Jammes] Here M occurs twice in Jammes so the corresponding serial number from Col 1 should be output in a new Column.
Even if there are two macros for bullet 1 and bullet 2, that would work.
