If statement question

[CJ]

I need to delete the first letter of a cell if it's a ( but I can't figure out how to tell isolate that letter. I can do a delete any first character, but it needs to be conditional

Any help would be vastly appreciated.

 

[Frank Kabel]

Hi
try the following formula in the adjacent row
=IF(LEFT(A1,1)="(",MID(A1,2,255),A1)

 

[Dave R.]

For a formula, this should work:

=IF(LEFT(A1,1)="(",RIGHT(A1,LEN(A1)-1),A1)

I need to delete the first letter of a cell if it's a ( but I can't

figure out how to tell isolate that letter. I can do a delete any first
character, but it needs to be conditional.

 

[Aladin Akyurek]

=IF(A1<>"",REPLACE(A1,1,--(LEFT(A1)="("),""),"")

I need to delete the first letter of a cell if it's a ( but I can't

figure out how to tell isolate that letter. I can do a delete any first
character, but it needs to be conditional.