"Show All" in Excel

P

PokerPaul

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.
 
G

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
 
Top