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
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: