Hi,
Select column B and press Ctrl+G Special Blanks OK. This will select
all the blank cells. Now press the right arrow key and press Ctrl+Enter
--
Regards,
Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com
"Soth" wrote in message
...
Hi-
A B C
Total $10
Total $10
Total 20
Total 20
Total $30
Total $40
I'm doing the tedious work by cut and paste the amounts from column C to
Column B. I have thousands of lines. Is there a quickest way to achive
this?
My results:
A B C
Total $10
Total $10
Total $20
Total $20
Total $30
Total $40
Thanks