Auto Deleting a range of numbers

  • Thread starter Thread starter Paula
  • Start date Start date
P

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
 
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.
Click to expand...

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


Regards
Claus Busch
 
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.
Click to expand...

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


Regards
Claus Busch
 
Hi Paula,

Am Wed, 6 Jun 2012 11:31:49 +0100 schrieb Paula:
the result should be

0152532012050112011300005D0844499464
Click to expand...

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
 
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.
Click to expand...

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


Regards
Claus Busch
 
Back
Top