Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to remove a space
Dear NG:
I copied and pasted my E-Z Pass statement into Excel as HTML. I sorted the data by tag number. If I highlight the cells with the "toll charges" for a specific tag number I SHOULD get the total toll charges in the lower status bar. Instead I get nothing. Apparently there is a blank space in front of each entry in the toll charges column. If I manually remove the blank space the charges total up in the status bar as they should. Is there any way to remove the space in front of each entry in the toll column other than manually removing them? I have a feeling I'm missing something very simple here. Thanks in advance for any suggestions. -Kevin |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I remove a space between a letters and set of numbers? | Excel Discussion (Misc queries) | |||
Remove Space in Text | Excel Discussion (Misc queries) | |||
How do I remove white space around a chart? | Charts and Charting in Excel | |||
How do I remove a hidden space in Excel cells | Excel Discussion (Misc queries) | |||
Remove leading space | Excel Worksheet Functions |