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" wrote:


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.


--
Aversin
------------------------------------------------------------------------
Aversin's Profile: http://www.excelforum.com/member.php...fo&userid=8238
View this thread: http://www.excelforum.com/showthread...hreadid=532749