Jun 12 2019 05:20 PM
Hello
I need to find and extract names in excel from one column to a new one.
For example in column A there are strings that contain car names. I need to extract one name like "Ford" to column B. I cannot find the first or second or last word as the words are spread out in the string.
Thanks for the help
Jun 12 2019 06:57 PM
Jun 12 2019 07:21 PM
Jun 12 2019 07:22 PM
Jun 12 2019 07:36 PM
@Jean GenibrelYou can use this formula on B2:
=IF(ISERROR(FIND("FORD",UPPER(A2))),".",A2)
and duplicate it to all cells. I usually displayed a dot "." instead of leaving it blank (just my preference)