sharky12345
Well-known Member
- Joined
- Aug 5, 2010
- Messages
- 3,404
- Office Version
- 2016
- Platform
- Windows
I'm trying to get the text after a string which can be found at any point in a cell.
The full string is 'VIDEO PRESENT: *YES/NO/NOT APPLICABLE'
What I need to extract is the answer, i.e. YES, NO or NOT APPLICABLE. The issue I have is that people have to delete the part of the answer which isn't relevant, leaving their answer, but I am getting all sorts of weird answers such as, *YES, /NO, *YES/ and any other variation you can think of!
So is there an efficient VBA method to grab the answer?
The full string is 'VIDEO PRESENT: *YES/NO/NOT APPLICABLE'
What I need to extract is the answer, i.e. YES, NO or NOT APPLICABLE. The issue I have is that people have to delete the part of the answer which isn't relevant, leaving their answer, but I am getting all sorts of weird answers such as, *YES, /NO, *YES/ and any other variation you can think of!
So is there an efficient VBA method to grab the answer?