If statement question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Hi
try the following formula in the adjacent row
=IF(LEFT(A1,1)="(",MID(A1,2,255),A1)
 
For a formula, this should work:

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



CJ said:
I need to delete the first letter of a cell if it's a ( but I can't
Click to expand...
figure out how to tell isolate that letter. I can do a delete any first
character, but it needs to be conditional.
 
=IF(A1<>"",REPLACE(A1,1,--(LEFT(A1)="("),""),"")

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