Check if cell value starts with specific words

[goranimo]

Hi all,

If cells in column F starts with specific words, then I would like to add a word at the end of the cell value.

I would be something like this:

If one or more cells in column F starts with "HYD." or "MECH." or "EL." Then

Add "_ILLUS" at the end of the cell values.

Else

Do nothing

If a cell contains i.e. MECH. Engine, the result will be MECH.Engine_ILLUS

[LeoTaxi]

Please Login or Register  to view this content.

Kind regards
Leo

[jindon]

Please Login or Register  to view this content.

[goranimo]

Thanks!