numbers within numbers
 

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

numbers within numbers
 

=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

numbers within numbers
 

On Sun, 7 Sep 2008 02:54:27 -0700, 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


Try the following formula:

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

Copy down as far as needed

Hope this helps / Lars-Åke

numbers within numbers
 

=LEFT(MID(A1,5,256),LEN(A1)-8)
--
Gary''s Student - gsnu200802

numbers within numbers
 

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

numbers within numbers
 

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

numbers within numbers
 

excelent...
thanks guys


"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

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

numbers within numbers
 

ummm YES IT IS A PROBLEM
this is a real number
19840040004
returns "0"

"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

numbers within numbers
 

yes - this works better
thanks all who supplied it

"Lars-Ã…ke Aspelin" wrote:

On Sun, 7 Sep 2008 02:54:27 -0700, 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


Try the following formula:

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

Copy down as far as needed

Hope this helps / Lars-Ã…ke