Hi,

Try this

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

Mike

"puiuluipui" wrote:

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!