[MacTUG] Returns in Excel - followup

Glenn Anderson anderson at uwaterloo.ca
Wed Feb 1 15:58:12 EST 2012


Stephen pointed out that Excel cells can also contain a "hard return" as well, which is indicated by the ascii code 13. So you may also have to deal with these.

Note: Depending on where the text came from, there maybe other non printable characters as well.

Excel does have a function clean that removes all non printable characters from a string. You have to be careful in that if you use clean, the two lines would be concatenated but without a space.





More information about the MacTUG mailing list