LAST 4 digit ( minus ) FIRST 4 digit

[makinmomb]

I have this text on a1 1501 - 1520

Cell b1 I need answer 20 , that is 1520 minus 1501 ( + 1 )

[gmr4evr1]

Try this in B1

Please Login or Register  to view this content.

[cbatrody]

Hi,

If the numeric values are in the same format across, try the following:

=RIGHT(A1,4)-LEFT(A1,4)+1

[AlKey]

or in case if your numbers are not always 4 digit each.

=REPLACE(A1,1,FIND("-",A1),"")-LEFT(A1,FIND("-",A1)-1)+1

Data Range

	A	B
1	1501 - 1520	20

[makinmomb]

Thank you all works as needed , will also collect that of
ALKEY maybe will need it else where

[gmr4evr1]

You're welcome, glad it worked for you.