Forum Discussion
Find and extract names excel from one column to a new one
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. ...
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)