| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Deleting blank spaces in cells
Hi all I have spreadsheet (converted from report) which contains cells that contain data and blank spaces. I want to keep the data and delete the blank spaces. All cells are not formatted the same eg some are 4 blank spaces and then text, some are text and 14 blank spaces. Please help! -- Mr Gow ------------------------------------------------------------------------ Mr Gow's Profile: http://www.excelforum.com/member.php...o&userid=34511 View this thread: http://www.excelforum.com/showthread...hreadid=542758 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Deleting Blank Cells Wholesale? | Excel Discussion (Misc queries) | |||
| pivot tables reports - altering display of (blank) cells | Excel Worksheet Functions | |||
| CONCATENATE problem with blank cells | Excel Discussion (Misc queries) | |||
| Blank cells represented in area charts | Charts and Charting in Excel | |||
| Copy down - special to fill only the blank cells | Excel Discussion (Misc queries) | |||
Threaded Mode
