I have an excel file with sever sheets.
In each sheet in column i have a listed text.
At the end of each text in every cell, i have something like this 'text...cited = 82'
The number after 'equal to varies from single to four digits.
So what I need is a macro which can pick a cell value under column B and put the text value (before '...cited = 82' in the adjacent cell (column C) and the number after 'equal to' in the adjacent cell under column D.
The number of rows can vary from as a few as 10 to 200 rows.