| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
killing empty spaces in unusall fashion ..
I am trying to create a sheet that will read 2 columns of another sheet that has empty spaces between the data (Rows) and I want to re-create the data in a new sheet that will re-fill the columns without the spaces.. Thanks e.g. : _COL_A_______COL_B_ apples 50 grapes 70 bannanas 40 peaches 80 TO: _COL_A_______COL_B_ apples 50 grapes 70 bannanas 40 peaches 80 -- Mhz ------------------------------------------------------------------------ Mhz's Profile: http://www.excelforum.com/member.php...o&userid=35980 View this thread: http://www.excelforum.com/showthread...hreadid=561376 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| why a reference to an empty cell is not considered empty | Excel Discussion (Misc queries) | |||
| how do I remove empty spaces trailing a text string? | Excel Worksheet Functions | |||
| In Bar Chart, can we display both figures and their respective %a. | Excel Discussion (Misc queries) | |||
| Sumproduct ... Empty Cells vs Spaces? | Excel Discussion (Misc queries) | |||
| Empty Cells, Spaces, Cond Format? | Excel Discussion (Misc queries) | |||
Threaded Mode
