how about this... =IFERROR(IF(RIGHT(C2,SEARCH(";wer_dane",C2)-2)=";wer_dane",C2&";POBR_DANE"),C2)