Formula Help (Search)

[How_Do_I]

How can I fix the following please. I'm getting a return because the formula is finding the "6th" in "26th" but that isn't what I want. I only wish to find "6th" for 6th, not the 6th in 16th, 26th, 36th etc.

Excel Workbook
	G	H
24	26th Battalion	26th (Service) Battalion
Sheet1

 

[AhoyNC]

Try:
Notice the added space in front of the 6th and 7th in the SEARCH.
SEARCH({" 6th"," 7th"}," "&G24)

Excel Workbook
	G	H
24	6th Battalion	6th (Service) Battalion
25	26th Battalion
26	27th Battalion
27	7th Battalion	7th (Service) Battalion
Sheet

 

[How_Do_I]

Thanks for that Ahoy...

 

[AhoyNC]

You're welcome. Thanks for the feedback.