Hey,
I am totally new to this! First time poster! Not sure if this can be done? I thought i would ask the experts.....
I have an excel sheet (see attached file) with extracted text from a bibliographic database. I would like to find specific words i.e. "Information Technology", for excel then to copy 10 characters before, the word itself and 10 characters into the next column.
So for example: Senior Mangers believe information systems is critical to business success.
I would a formulae / VB script to find the text "information systems" and find 10 characters before and 30 characters after.
so it would read: 'era believe information systems is critical' in the next column. I have found a way to search the text string to return a true or false statement, but am struggling to do this activity.
Does anyone have any suggestions to do this in MS excel via formulaes or does this need VB Coding.
Please provide source code or formulaes?
Any help is really appreciated.
Bookmarks