Editing out numbers in a cell

A

Aversin

I have a colom of numbers all in the same format xxxx-xxxxxxx-xxxx
4numbers - 7 numbers - 4numbers

What I need to do is to remove the first 4 and last 4 numbers and the
dash with them.

Any ideas.
 
K

karmaisgreat

Thats easy, clear out several columns to the right of the column, go to
data-texttocolumns- then select delimited and use the "-" as the value. You
will then have three columns xxxx then xxxxxxxx then xxxxx. Then you can
delete the two unneeded columns. ;)
 
C

Camilo

Applys to the format you mentioned (ie. xxxx-xxxxxxx-xxxx)

=MID(A1,6,7)
--
Hope this Helps!
Camilo

Objective: To help one person each day!

Feedback is greatly appreciated! Please let me know if I've answered your
question or if my post was helpful to you?
 
C

Camilo

Who rocks!!?;) Me or Karma.. Actually, it would be great for both of us if
you rated our posts so that we knew which solution worked for you, even if
they both did! Thanks Aversin!
--
Hope this Helps!
Camilo

Objective: To help one person each day!

Feedback is greatly appreciated! Please let me know if I've answered your
question or if my post was helpful to you?
 
G

Gord Dibben

Easier yet................At Step 3 of T to C, choose to "do not import this
column(skip)"

You will not have to deal with the two unwanted columns.


Gord Dibben MS Excel MVP
 
Top