I GOT IT! I used the CLEAN and SUBSTITUTE functions to replace 013 with 127.
I then went into Text to Columns and split by char(127) and it worked.
Thanks for all the help.

"Dave Peterson" wrote:

> Are you positive that all those characters are char(127)'s?
>
> Chip Pearson has a very nice addin that will help determine what that
> character(s) is:
> http://www.cpearson.com/excel/CellView.htm
>
> QDZF wrote:
> >
> > When I did this, only the first section broke into the new column. The rest
> > did not appear at all. There's 6 of these breaks in the string. How do I
> > get the others to break into new columns?
> >
> > "sebastienm" wrote:
> >
> > > Hi,
> > > No need to Replace; you can directly use the 'Text To Column' feature. As
> > > the delimiter, choose 'Other' and type in the char 127 by typing: ALT + 0127,
> > > ie type 0127 WHILE pressing the ALT.
> > > --
> > > Regards,
> > > Sébastien
> > > <http://www.ondemandanalysis.com>
> > >
> > >
> > > "QDZF" wrote:
> > >
> > > > HAVE A FILE WITH A STRING OF TEXT BROKEN BY CHAR(127). I WOULD LIKE TO BREAK
> > > > THAT STRING AT EACH OCCURENCE OF CHAR(127). EASIEST WAY I COULD THINK OF WAS
> > > > TO REPLACE IT WITH A SYMBOL AND THEN USE TEXT TO COLUMNS. IS THERE A BETTER
> > > > WAY THAN THIS?
>
> --
>
> Dave Peterson
>