consolidation of adjacent columns

Thanks ScottO,
I had tried what you suggested before but I guess that my spaces were not in the right place....
Now is there an easy way to to this for a gazillion entries in both columns without having to enter the formula each time???

Thanks,
rooniwife

If the formula that you want to copy down is in a column right beside one of the data columns, and
there's no blank cells in that column of data, then do this ...
1. Select the cell with the formula
2. Double-click on the "fill handle"

The "Fill Handle" is the small black square in the bottom right corner of the selection border.

Rgds,
Scott

"rooniwife" <rooniwife.1rpnef_1120590316.8173@excelforum-nospam.com> wrote in message
news:rooniwife.1rpnef_1120590316.8173@excelforum-nospam.com...
|
| Thanks ScottO,
| I had tried what you suggested before but I guess that my spaces were
| not in the right place....
| Now is there an easy way to to this for a gazillion entries in both
| columns without having to enter the formula each time???
|
| Thanks,
| rooniwife
|
|
| --
| rooniwife
| ------------------------------------------------------------------------
| rooniwife's Profile: http://www.excelforum.com/member.php...o&userid=24904
| View this thread: http://www.excelforum.com/showthread...hreadid=384425
|

thanks a bunch scotto
rooniwife