Auto Deleting a range of numbers

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
 
C

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

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


Regards
Claus Busch
 
P

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

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


Regards
Claus Busch
 
C

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
 
P

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

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


Regards
Claus Busch
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

deleting numbers prefix 3
Count in a range of numbers 8
Excel Macro to automatically go to the right of the last colored cell 0
MACRO RUN random percentage and copy of column values 1
calculate percentage of numbers <= zero in a given range 1
formula for bingo 1
Checking numbers in range 14
Creating independant Arrays of sequential numbers 1

Top