Text to column

Giganews Newsgroups
Subject: Text to column
Posted by:  Eileen (Eileenli…@yahoo.com)
Date: Thu, 2 Oct 2003

Is there a quick way to separate the below column into
letter and part#(hundreds of rows)?

from:

IC19-004-01
TRS30-000-01
C12-001-01
27-044-01

To:
IC  19-004-01
TRS  30-000-01
C    12-001-01
    27-044-01

Replies