If I have the following phrase in cell A1:
new home vinyl siding cost
How do I find the whole words to the left or right of the word "siding" using a formula?
Result of formula 1:
vinyl siding
Result of formula 2:
siding cost
I honestly don't understand FIND, SEARCH, functions well enough to provide an attempt at solving this. I think LEN would be involved here too?
Bookmarks