The ASC function is a very obscure function depending on which language you use. In fact, it's not even available in Excel's Insert Function dialogue. Yet it is available if you enter "=ASC" in a cell.

ASC takes 1 required argument and no optional arguments:

Syntax: ASC(text)

#1)
Using the ASC function:
Be aware:
The text in the source cell (C4 in this example) is not altered itself and the formula cell (C8 in this example) contains only the result of a formula and not the text itself. To store the cleaned up text in cells, you can select and copy the cells that are using the ASC function and then do a Paste Special to paste only the cleaned up text and into the destination cells.
#2)
The arguments for the ASC function are:
Argument Required? Description
text Required the text or a reference to a cell that contains the text you want to change. If text does not contain any full-width letters, the text is not changed.

Summary

ASC is a simple but useful function to clean up undesired spaces from text in any cell.
comments powered by Disqus