Hi,
I have an Excel spreadsheet with about 17000 lines.
In certains cells of col B, there is a string starting with "(If ISCunable to resolve, " then the rest of the string may differ.
I need to cut the string out of the cell, and paste it into the cell next to it (col C).
I found some code for matching strings, and copying to a new sheet, but I have no idea how to adapt it, it's chinese to me!
Any help much appreciated.
I have an Excel spreadsheet with about 17000 lines.
In certains cells of col B, there is a string starting with "(If ISCunable to resolve, " then the rest of the string may differ.
I need to cut the string out of the cell, and paste it into the cell next to it (col C).
I found some code for matching strings, and copying to a new sheet, but I have no idea how to adapt it, it's chinese to me!
Any help much appreciated.