Enter the following in B1 and copy down;

=MID(A1,5,LEN(A1)-8)

This will remove first and last four digits. It is assumed that all numbers
will have at least 9 digits.

"EngelseBoer" wrote:

is it possible to rundown a column of numbers in A
and return it in B without the 1st 4 and last 4 didtgets?

ie whether the number is 12, 13, 14, 15, ditgets long
i want the center bit - in my case - to get the breeders number
extracting the YEAR (1st 4 ditgets) and (dog number (last 4 Digets)

A B
200812340001 = 1234
2007567890001 = 56789