Find a certain word in a string in column B and then copy it to the left cell

[GenjutsuGhost]

I have the following problem.

I need to find a certain word in a string in column B and then copy it to the left cell of the cell.

So if there is a word in column B called

""Dog": "","

I need the hole string in column B to copied to column A in the exact same row.

Two things maybe to notice is that all words are in quotation marks and they are all unique the same word can be found multiple times in column B, so I can't just find and replace, because they must be copied to the left in column A in the same row.

I hope this clarifies my problem.

The exact same format applies to all strings in column B, but then with a different word:

""Dog": "","

 

[Joe4]

Welcome to the Board!

Try putting this formula in cell B1 and copy down for all rows:

=IF(ISNUMBER(SEARCH("Dog",A1)),A1,"")

 

[Peter_SSs]

Welcome to the MrExcel board!

I think that you will need to include the quote marks to ensure that you don't get examples like row 3 below returned as well.

21 08 05.xlsm
	A	B
1
2	""Dog": "","	""Dog": "","
3		""Endogamy": "","
Search Word

Cell Formulas
Range	Formula
A2:A3	A2	=IF(ISNUMBER(SEARCH("""Dog""",B2)),B2,"")

BTW, I suggest that you investigate XL2BB for providing sample data to make it easier for helpers by not having to manually type out sample data to test with.

 

[Joe4]

Another thing I should mention:

SEARCH is not case-sensitive. So in searching for "Dog" it will also return things like "dog".
If case-sensitivity is important to you, then you can use the FIND function instead of SEARCH. It works the same way, but is case-sensitive.