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.

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


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


"Νικος" <@discussions.microsoft.com> wrote in message
news:7432ECC5-ADE9-4093-B7B5-(E-Mail Removed)...
> 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.

thanks

"Chip Pearson" wrote:

> See http://www.cpearson.com/excel/noblanks.htm for example formulas and VBA
> code.
>
>
> --
> Cordially,
> Chip Pearson
> Microsoft MVP - Excel
> Pearson Software Consulting
> www.cpearson.com
> (email on the web site)
>
>
> "Νικος" <@discussions.microsoft.com> wrote in message
> news:7432ECC5-ADE9-4093-B7B5-(E-Mail Removed)...
> > 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.
>