Last 4 digit

[puiuluipui]

Hi, i need to extract the last 4 digit from a number.
ex:
A B
0788198256 8256
But if the first number of extracted 4 is zero, i need it to be transformed
into 1.
ex:
A B
0788190248 1248

Can this be done?
Thanks!

 

[Mike H]

Hi,

Try this

=IF(RIGHT(A1,4)+0<1000,RIGHT(A1,4)+1000,RIGHT(A1,4)+0)

Mike

 

[Jacob Skaria]

=VALUE(IF(LEFT(RIGHT(A1,4),1)="0","1"&RIGHT(A1,3),RIGHT(A1,4)))

If this post helps click Yes

 

[puiuluipui]

It's working very well. Thanks!

"Mike H" a scris:

 

[puiuluipui]

It's working very well. Thanks!

"Jacob Skaria" a scris:

 

[puiuluipui]

It's working very well. Thanks!

"Ron Coderre" a scris: