excel help - need to find text

  robert01 13:42 13 Aug 2013

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 2013

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 2013

Brilliant - you have saved me hours, thanks !

  Zak 16:44 13 Aug 2013

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.

Elsewhere on IDG sites

Samsung Galaxy S9 review

Wacom Cintiq Pro 24 and 32 review – hands-on

When is the next Apple event?

Gmail : comment annuler l’envoi d’un e-mail ?