hi
a bit vague. from your statement "form the end of column B", this pop in my
mind
=if(A2 = "String x", left(B2,Len(B2)-1),"")
this would remove the last character from column B.

but could you supply and example of string x and data in column B.

Regards
FSt1

"msnyc07" wrote:

By which I mean removing part of a string.

Basically I want do something like

If Column A Contains String X then Remove Character A from end of Column B