"Show All" in Excel

[Guest]

Is there a "Show All" or something similar in Excel like there is in Word? I
am having trouble with hidden text (spaces) in the "COUNTA" function.

 

[Gord Dibben]

Paul

No "show all" available in Excel.

If you have spaces or other junk in cells, you can try the TRIM or CLEAN
Functions.

Download Chip Pearson's CELLVIEW add-in from

http://www.cpearson.com/excel/CellView.htm

Load through Tools>Add-ins.

Select the data and Chip's add-in will show you what the characters are.

David McRitchie's TRIMALL macro will also be of assistance. Cleans up what
TRIM and CLEAN miss.

http://www.mvps.org/dmcritchie/excel/join.htm#trimall


Gord Dibben Excel MVP