Macro to match certain text in wrapped texted cells

[christian2016]

Hi Guys,

I need a macro to find/match text within a cell with multiple text and return the matched texted.

Criteria to match
BACKDATE - COMPLEX
BACKDATE - SIMPLE
LOAN REVIEW
LOAN REVIEW - DDR
LOAN REVIEW - FREQ
LOAN REVIEW - MARGIN

Please refer to the spreadsheet.

Any help is greatly appreciated.

Thanks

[tamthat]

I think don't need macro, only use formulas is enought!

Please Login or Register  to view this content.

[christian2016]

Thanks I had this formula although it will use whatever text that is in the top of the cell.

Is there a formula to only extract top line text that matches the criteria

[tamthat]

Thanks I had this formula although it will use whatever text that is in the top of the cell.

Is there a formula to only extract top line text that matches the criteria

Yes, it was the formula used. @@

Please Login or Register  to view this content.

Ctrl + Shift + Enter!
With J2:J7 is the criteria!

[christian2016]

Thanks Works great.

Also if text is too long the formula returns a blank value.
If I remove some text the formula will return a value.

Is there a limit on the text and am I able to fix this issue ?

[tamthat]

Thanks Works great.

Also if text is too long the formula returns a blank value.
If I remove some text the formula will return a value.

Is there a limit on the text and am I able to fix this issue ?

Yes, you can use formulas len(A1) to check how long string in text and set limited of text. Ex: if(len(A1)>500,"",My formulas in #4). @@