excel help - need to find text

  robert01 13:42 13 Aug 13
Locked
Answered

i have a list on excel i am trying to clean up - i need to find everything with (blu-ray) after a title and highlight it with an x next to it for a future dataload

i can do it with ctrl f and keep clicking next as i put an x against each one but there are 1000s of lines - is there a formula i can use to do this for me

  Zak 15:16 13 Aug 13
Answer

Do you want the x to be in the next or subsequent column? If so you will find the basic formula

In Excel how to search a text string + get TRUE/FALSE result

In formula or True enter X and for False "" This will leave that cell blank where there is no blu-ray You can then copy by dragging down the formula in the new column

  robert01 15:29 13 Aug 13

Brilliant - you have saved me hours, thanks !

  Zak 16:44 13 Aug 13

Just to add I have found this formula the best:

=IF(ISERROR(SEARCH("blu-ray",A1)),"", "X")

This thread is now locked and can not be replied to.

Surface Pro (2017) vs Surface Pro 4

20 groundbreaking 3D animation techniques

How to mine Bitcoin on Mac