Hi Excel masters,
I have a string of text in one cell that's broken up by multiple brackets. The brackets include a date stamp and the name of the person who changed the record. It looks like this:
[MMM-DD-YY fname lname] desired text 1
[MMM-DD-YY fname lname] desired text 2
[MMM-DD-YY fname lname] desired text 3[
(The end bracket "[" after "desired text 3" is intentional--it's been concatenated onto the text string.)
What I'm trying to do is find a formula to extract "desired text 2" into one cell and then "desired text 3" into a separate cell, but I don't understand how to find the second and third set of brackets. Does anyone know of a formula that would work?
Thanks!
Bookmarks