Word Search in excel

Hi All,

How do i search for a specific word within a column A, and return word 'email' in column B?

Eg:
Column A Column B
"Branch email ID AMBB220 unable to received and sent email" email

Thanks in advance.

Put this in B1:

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

then copy down.

Hope this helps.

Pete

Hi Pete,

It helps a lot~

Thank you very much.

Best wishes,
Chloe

Glad to be able to help.

If that takes care of your original question, please select Thread Tools from the menu above your first post and mark this thread as SOLVED.


Pete

Thanks again Pete. I was searching around where to change the thread status to 'SOLVED', and here you helped me out again.