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. ...
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
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