=IF then,this & that, else other...

[etm]

My 1st post! I am going to risk being embarrassed but I want to learn if, then statements (among other things in Excel...).

I have a column of numbers. IF the number begins with "1", delete the "1" and keep the rest of the number intact. If the number does not begin with "1" just leave intact & go to next record.

I started with:

=if(LEFT(A1)="1",""&RIGHT(A1),A1)

but that deleted everything except the last digit if the number started with 1...Instead of "RIGHT" I need a "REMAINING".

Thanks! Elaine

 

[njimack]

Welcome to the board. A few ways to achieve this, first one that comes to mind is
=IF(LEFT(A1)="1",RIGHT(A1,LEN(A1)-1),A1)

 

[Gerald Higgins]

Neil, I think that should be

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

Edit - and now it is

 

[njimack]

Edit - and now it is

Great minds think alike!

 

[etm]

Thank you Neil & Gerald. Perfect.