numbers within numbers
hope that wont be a problem in my application
"Lars-Åke Aspelin" wrote:
This formula will not work in general.
Take this example
2008200890001
It should return 20089 but your formula gives just 9.
Lars-Åke
On Sun, 7 Sep 2008 03:08:17 -0700, excelent
wrote:
=SUBSTITUTE(SUBSTITUTE(A2,LEFT(A2,4),""),RIGHT(A2 ,4),"")
"EngelseBoer" skrev:
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
|