Excel formula for String manipulation

Filed in Uncategorized Leave a comment

For converting “CId = @CId” to¬†CId = ISNULL(@CId, CId)” in excel below is the formula:

=CONCATENATE(MID(F2,1,(FIND(“@”,F2)-1)),” ISNULL(“,MID(F2,FIND(“@”,F2),LEN(F2)),”, “,MID(F2,FIND(“@”,F2)+1,LEN(F2)), “)”)

TOP