Home > Uncategorized > Excel formula for String manipulation

Excel formula for String manipulation

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)), “)”)

Comments are closed.

TOP