Help with a quick Excel Formula please

[thedoc46]

Hi,

How do I remove the 1st digit if there's an 8 on a column ?

Example number 81906298 I just need it to show 1906298

I need to go down the entire column and any with a leading 8, that number needs to be removed.

I know a formula exists, i just don't know how to do it.

This would save me going down 686 lines and manually removing.

Thanks in advance.

 

[thedoc46]

Hi,

How do I remove the 1st digit if there's an 8 on a column ?

Example number 81906298 I just need it to show 1906298

I need to go down the entire column and any with a leading 8, that number needs to be removed.

I know a formula exists, i just don't know how to do it.

This would save me going down 686 lines and manually removing.

Thanks in advance.

I think i've figured it out.

=RIGHT(A3, LEN(A3)-8) Removes first 8 characters from A3 (B1)

 

[ian54]

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