Thanks this is what I ended up with after some research online as well,
needed to check for two different conditions in two different columns;

=IF(RIGHT(R5848,1)="I",IF(ISNUMBER(SEARCH(",
Inc",O5848)),LEFT(R5848,LEN(R5848)-1),R5848), R5848)

"FSt1" wrote:

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