Blank cells in Excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Νικος - 19 Jun 2007 19:22 GMT

Hi.
I have some columns in Excel which include numbers and blank cells. Is there
anyway (with the use of functions) to copy these numbers to the next columns
without blank cells and in continuing order ?
(For ex. Lets say i have the column A in which is: A1= 45,78 A2=53
A3=123,90 A4=(blank) A5=(blank) ............A99=(blank) A100=240. I would
like in column B: B1=45,78 B2=53 B3=123,90 and B5=240. Is that possimple
using functions?)
Thank you.

Reply to this Message

Chip Pearson - 19 Jun 2007 19:56 GMT

See http://www.cpearson.com/excel/noblanks.htm for example formulas and VBA
code.

Signature

Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting
www.cpearson.com
(email on the web site)

> Hi.
> I have some columns in Excel which include numbers and blank cells. Is
[quoted text clipped - 8 lines]
> using functions?)
> Thank you.

Reply to this Message

Νικος - 20 Jun 2007 06:24 GMT

thanks

> See http://www.cpearson.com/excel/noblanks.htm for example formulas and VBA
> code.
[quoted text clipped - 11 lines]
> > using functions?)
> > Thank you.

Reply to this Message

Rate this thread: