Find text based on multiple criteria

Joined
May 3, 2011
Messages
1
Reaction score
0
Hi Guys,

Using Excel 2007, I am needing to find some text in a string. For example I have the following types of text in the same row, cells A1-A1500

Month:Jan>>Day:Tues
Month:Mar,Feb>>Day:Tues

Now I need to extract only the text between "Month:" and either "," or ">" and deposit the text into the next row.

Much appreciated.

Thanks
 
Last edited:
Back
Top