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