'Reverse' Concatenate
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
|