Microsoft Office Tutorials and References
In Depth Information
operating system. For example, you can use CLEAN to remove some low-level
computer code that is frequently at the beginning and end of data fi les and
cannot be printed. Guru Tip: Clean is a great idea that is severely out of date. It
removes character codes 1 through 31, 129, 141, 143, 144, and 157. It misses
a number of other characters which have become popular due to HTML and
web pages. Personally, I wish that CLEAN and TRIM would work with character
160 – the non-breaking space that happens when someone codes   into
a web page.
CODE(text) [Category: Text]
Returns a numeric code for the fi rst character in a text string. The returned code
corresponds to the character set used by your computer. Guru Tip: Use this
to learn the character code for a letter. For example, =CODE("A") will remind
you that a capital A is 65. This is good for discovering the character number
of an problematic character. In the fi gure below, someone used Alt+Enter to
enter three lines of an address in cell A1. The formula in D11 identifi es that the
Alt+Enter actually inserts a character code 10 to represent the Alt+Enter. The
formula in E1 then uses SUBSTITUTE and CHAR to replace the line feeds with
semi-colons. After using paste values in E, you could use Text to Columns to
successfully break out a whole column of addresses entered like cell A1.
Search JabSto ::

Custom Search