Auto Deleting a range of numbers

[Paula]

Hi there

I have a range of numbers ie. 0010010152532012050112011300005D08444994646 x
3000
I wish to delete the first say 6 numbers and the last 8 numbers, is this
possible.

ty
in advance

 

[Claus Busch]

Hi Paula,

Am Wed, 6 Jun 2012 10:52:40 +0100 schrieb Paula:

I have a range of numbers ie. 0010010152532012050112011300005D08444994646 x
3000
I wish to delete the first say 6 numbers and the last 8 numbers, is this
possible.

what shall be the result?
0152532012050112011300005D0844499464
or
0152532012050112011300005D084 x 3000


Regards
Claus Busch

 

[Paula]

Hi Claus


the result should be

0152532012050112011300005D0844499464

ty



"Claus Busch" wrote in message
Hi Paula,

Am Wed, 6 Jun 2012 10:52:40 +0100 schrieb Paula:

I have a range of numbers ie. 0010010152532012050112011300005D08444994646
x
3000
I wish to delete the first say 6 numbers and the last 8 numbers, is this
possible.

what shall be the result?
0152532012050112011300005D0844499464
or
0152532012050112011300005D084 x 3000


Regards
Claus Busch

 

[Claus Busch]

Hi Paula,

Am Wed, 6 Jun 2012 11:31:49 +0100 schrieb Paula:

the result should be

0152532012050112011300005D0844499464

your numbers in column A from A1 on. Then in a helper column:
=MID(A1,7,LEN(A1)-14)
Copy the helper column and paste it back as values


Regards
Claus Busch

 

[Paula]

Hi Claus


the result would be

0152532012050112011300005D0844499464


ty

in advance

"Claus Busch" wrote in message
Hi Paula,

Am Wed, 6 Jun 2012 10:52:40 +0100 schrieb Paula:

I have a range of numbers ie. 0010010152532012050112011300005D08444994646
x
3000
I wish to delete the first say 6 numbers and the last 8 numbers, is this
possible.

what shall be the result?
0152532012050112011300005D0844499464
or
0152532012050112011300005D084 x 3000


Regards
Claus Busch