deleting numbers prefix

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

Paula

Hi there

Can anyone tell me how to delete numbers say 6 digits prefix and say 8
numbers right to left leaving the centre visible.

ie. 00001010456987123000101010

i have 500 in Col A

ty in advance
 
Hi Paula,

Am Wed, 6 Jun 2012 14:01:52 +0100 schrieb Paula:
Can anyone tell me how to delete numbers say 6 digits prefix and say 8
numbers right to left leaving the centre visible.

ie. 00001010456987123000101010
Click to expand...

didn't you read my answer in the other thread?
In a helper column try it with:
=MID(A1,7,LEN(A1)-14)
then copy the helper column and paste it back as values.
Or try it with VBA:

Sub CutNum()
Dim LRow As Long
Dim first As String
Dim last As String
Dim rngC As Range

LRow = Cells(Rows.Count, "A").End(xlUp).Row
For Each rngC In Range("A1:a" & LRow)
first = Left(rngC, 6)
last = Right(rngC, 8)
rngC = Replace(Replace(rngC, first, ""), last, "")
Next
End Sub


Regards
Claus Busch
 
hi Paula,

=LEFT(RIGHT(A1,LEN(A1)-6),LEN(RIGHT(A1,LEN(A1)-6))-8)

result : 1045698712300

--
isabelle



Le 2012-06-06 09:01, Paula a écrit :
 
Back
Top