Find text separated by line breaks in same cell

Is it possible in Excel to find text within a cell separated by line breaks? Suppose the text consists of the following in the same cell:

“aaa” on one line; a blank line; and then on the next line “bbb”.

How can I find all instances of this combination in a Worksheet containing thousands of rows?

Thanks in advance.





By: TC

2 thoughts on “Find text separated by line breaks in same cell

  1. ig

    My partner and I absolutely love your blog and find the majority of your post’s to be exactly I’m looking for.

    Would you offer guest writers to write content for yourself?
    I wouldn’t mind producing a post or elaborating on a number
    of the subjects you write in relation to here.
    Again, awesome blog!

Comments are closed.