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. ...
You may COUNTIF the cell to the left contains “Ford”, like this:
=IF(COUNTIF(A2,”*Ford*”),
A2,
“”)
=IF(COUNTIF(A2,”*Ford*”),
A2,
“”)