how can i remove the first 3 caracters from one column ?

[Atomic Shrimp]

Sorry - that's me - not familiar enough with Excel function names - string conversion to number is the VALUE function, not 'Val'.

how about:

=IF(VALUE(A2)<>(VALUE(A1)+1),"<<Gap","")

 

[basante]

Sorry - that's me - not familiar enough with Excel function names - string conversion to number is the VALUE function, not 'Val'.

how about:

=IF(VALUE(A2)<>(VALUE(A1)+1),"<<Gap","")

works perfect, thanks