How to find partial information in a cell and replace the whole cell content with a value?

Hi Everyone,

I am coding my excel file as a preparation for some SPSS data analysis. I want a cell to have the new value "1" when a current cell contains the text "Research & Development Services" and I want the cell to have the new value "0" when the cell contains anything but "Research & Development Services". I attach a picture in order to make things more clear. I genuinely hope somebody can help me out, because the find and replace function only replaced the "Research & Development" text and left the other text in the cell.

Thank you!

Glenn


Schermafbeelding 2013-06-26 om 17.09.09.png

Try this formula in column B1: =IF(A1="Research & Development Services",1,0)

Research & Development Services 1
Testing Services 0
Work Services 0