Find text based on multiple criteria

M

March

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:

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Find text - worksheet function or macro? 5
Find the same text multiple times in a string seperated by commas 1
sumif based on 1 criteria 1
Array formula based on text and dates.. 3
How to filter rows data based on background color of individual cells 1
Conditional Format based on sub-string 3
Formula to check two rows for equivalence 3
SUMIF with criteria "<>" & "=" 4

Top