The char(10) can be changed via edit|replace (or you can use data|text to
columns and specify the delimiter as alt-0010).

But I've never had any luck doing the same thing with char(13).

You can use a helper column filled with formulas like:

=substitute(a1,char(13)&char(10),"|")

Drag it down the column.
Convert to values and use data|text to columns against this helper column (and
use | as the delimiter)

QDZF wrote:

Great addin! It says it is not char(127). When I view the line through the
addin, it shows two characters. One is 013 and the next is 010. I tried
'Text to Columns' using Alt + every variation of these codes and nothing
worked. Now that we know what we are dealing with, is there something else I
should be doing?

Thanks.

"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


--

Dave Peterson