Hi, I have column A filled with a phrasal verb. I need to find the same expression in column B and replace it with (.............)
Take care of I had to take care of my daughter because she was ill.
Take charge of I will take charge of the project and ensure it is completed on time.
Take drugs It is not safe to take drugs because they can be harmful to your health.
Take exercise I take exercise every morning to stay healthy and fit.
Take medicine You should take medicine to relieve your headache.
Take notes It's important to take notes during class so you can review them later.
I am on a macbook and everytime I try and paste in a formula on cell A1 for example, it replaces the text. I tried pasting formula only and I couldn't.
Should I be using a LOOKUP or MATCH function or even a substitute function.
Thanks
Bookmarks