How Do I Extract Text After Charecter and String?

[Legacy 286866]

Kind of lost on what to do here. I have a a cell in A2 that is in the format shown below. I need to extract all text after Query Summery - and to end at the ============ beffore Query. All it should pull through is New event testing in area 15. I have mutiple entries like this in the A column but in the same format. Not a clue on how I would extract this.

============
Main Data - Information on this is the main data
============
Query Summery - New event testing in area 15
============
Query - New mine created for testing in minecraft and brought forwards 15 times today
============

 

[Rick Rothstein]

Kind of lost on what to do here. I have a a cell in A2 that is in the format shown below. I need to extract all text after Query Summery - and to end at the ============ beffore Query. All it should pull through is New event testing in area 15. I have mutiple entries like this in the A column but in the same format. Not a clue on how I would extract this.

============
Main Data - Information on this is the main data
============
Query Summery - New event testing in area 15
============
Query - New mine created for testing in minecraft and brought forwards 15 times today
============

Give this a try...

=MID(A1,SEARCH("Query Summery",A1)+16,SEARCH("==",A1,SEARCH("Query Summery",A1)+1)-SEARCH("Query Summery",A1)-17)


SIDE NOTE: I think you have spelled "Summery" incorrectly for how you are using it, although it might be correct depending on where you live and local spelling rules. Here in the US, "summery" is an adjective meaning "fit for summer" whereas the word I think you want is "summary" meaning "covering the main points in a concise manner".

 

[ismii]

So the cells value is one long string like
"============Main Data - Information on this is the main data============Query Summery - New event testing in area 15============Query - New mine created for testing in minecraft and brought forwards 15 times today============"?

formula

=MID(LEFT(A2,FIND("============Query - ",A2,1)-1), FIND("Query Summery - ",A2,1)+16,LEN(A2))

if using VBA I'd use split() via the ============


Edit:
What Rick said :P
Got sidetracked...

 

[Legacy 286866]

Ah yes I did spell that wrong Rick. Well spotted ^_^. I edited what you wrote above and made it a bit smaller. Seems to do the trick.
<code>=MID(LEFT(A2,FIND("Query - ",A2)-16),FIND("Query Summery - ", A2)+16,999)</code>