Find Cell Address from String Search

[littlefish]

I have a converted spreadsheet (from a PDF) that contains location records in multiple rows and columns for hundreds of properties. I would like to create a separate tab of two columns (property name/cell address,) based on a search for "NAME:" in the all of the data. The conversion did not align the "NAME:" field in the same column, and there are instances of other data preceding "NAME:" in the cell. Each cell that contains "NAME:" also contains the property name. Having the cell address would allow me to extract other data for each property as needed.

Thanks in advance.

LF