I have some imported data that I’d like to search for a partial string within a sentence.
fields that are imported populate cells A1 through A250.
as the data is imported as a colum and not an array, sometimes cell A13 in one import does not match another pasted import.
i‘m looking for a way to search the cell column for “g1.“ In a Cell that contains “g1. Contractor name“.
so if i search for this in a cell and it’s located in cell A13 in one import and cell 15 in another that fits the criteria for the text containing “g1.”
‘now here’s where my issue occurs. I find the cell containing “g1.“ and is cell A11, I need the data in cell A12. Can this be done in one formula in a single cell?
fields that are imported populate cells A1 through A250.
as the data is imported as a colum and not an array, sometimes cell A13 in one import does not match another pasted import.
i‘m looking for a way to search the cell column for “g1.“ In a Cell that contains “g1. Contractor name“.
so if i search for this in a cell and it’s located in cell A13 in one import and cell 15 in another that fits the criteria for the text containing “g1.”
‘now here’s where my issue occurs. I find the cell containing “g1.“ and is cell A11, I need the data in cell A12. Can this be done in one formula in a single cell?