Forum Discussion

Jean Genibrel's avatar
Jean Genibrel
Copper Contributor
Jun 13, 2019

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.  I cannot find the first or second or last word as the words are spread out in the string.

Thanks for the help

excel
Formulas and Functions

4 Replies

  • TheThinker1958's avatar
    TheThinker1958
    Copper Contributor
    Jun 13, 2019

    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)

     

  • Twifoo's avatar
    Twifoo
    Silver Contributor
    Jun 13, 2019
    You may COUNTIF the cell to the left contains “Ford”, like this:
    =IF(COUNTIF(A2,”*Ford*”),
    A2,
    “”)
  • 3409mac's avatar
    3409mac
    Copper Contributor
    Jun 13, 2019
    Hi Jean & the thinker 1958; at first i had a similar issue as you have Jean, a good mate informed to try the same as The Thinker 1958 is suggesting and it really does work and much quicker having to enter everything each time.
  • TheThinker1958's avatar
    TheThinker1958
    Copper Contributor
    Jun 13, 2019
    hi Jean,
    why don't you just create a filter for column A to show only cells that CONTAINS "FORD".
    Then, when you just see the cells that you need, go to column B and enter the formula: =A2
    (I'm assuming the first cell with FORD in it is on cell A2). Then you just paste that cell on all the cells in column B that you see.
    Now you can take out the filter and convert those formulas in column B into Values.
    I hope this helps with your issue

Resources