| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Rephrased - Remove blank cells - no sorting, copy or pasting
Is there a "formula" that I can put into RowB that will remove the blank
cells from RowA without sorting or manually copying and pasting? I posted this earlier but didn't get an anwer if there is a formula or not. Example: A B 1 8 8 2 6 6 3 2 4 2 5 5 5 6 6 6 4 7 8 9 4 Thank you for your help Luke |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| remove blank cells - no sorting | Excel Worksheet Functions | |||
| putting a (.) period in blank cells when pasting data | Excel Worksheet Functions | |||
| Copy and pasting ref cells is not working | Excel Discussion (Misc queries) | |||
| Remove blank cells from a range | Excel Discussion (Misc queries) | |||
| remove paddings in cells when pasting from excel to word? | Excel Discussion (Misc queries) | |||
Threaded Mode
