Trying to find text of 2 words like city and state "dallas, TX" from sheet2 in sheet1 ColumnA(anywhere in wrapped text)
example of text in Sheet1 columnA
Robert is living in dallas, TX with his aunt.
I tried vlookup but it only search exact text in cell not somewhere in wrapped cell...
I'm trying to create a template and I need a few cells to be wrapped texted. When I paste text into those cells it some how changes back to no wrapped text. Is there a way to keep (lock) the cell so it is always wrapped text?