Editing out numbers in a cell

[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.

 

[Guest]

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.

 

[Aversin]

Thanks!!!!!!!!!

You Rock

 

[Guest]

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?

 

[Guest]

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?

 

[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