I'm struggling with the scenario below...
A certain cell on a spreadsheet uses the following format
"<* Description: Text I want>< Date:MM/DD/YYYY *>"
I'm sick as a dog and trying to figure this out, but every approach I've taken just seems backwards and doesn't seem to work. I've tried pulling everything after the first : and before the first >... I don't know I feel like I'm going after this the wrong way. Any suggestions?
This is the result I'm looking for.
DescText = "Text I want"
DateNeeded = "MM/DD/YYYY"
If I can get this, I can then dump those variables where they are needed.