| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Removing blank cells
I have a column with about 500 addresses. There is a blank cell in between
each address. Is there any way to remove all the blank cells at once WITHOUT sorting the addresses? The addresses aren't in any alphabetical or numerical order, and I have to keep them in the order they are currently in, So I can't use the sort function. Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SAP to Excel. Removing blank cells HELP!!!! | Excel Discussion (Misc queries) | |||
| Removing blank cells from a column | Excel Worksheet Functions | |||
| Removing blank cells... | Excel Discussion (Misc queries) | |||
| Removing blank cells | Excel Worksheet Functions | |||
| Removing blank cells in a column | Excel Worksheet Functions | |||
Threaded Mode
