Blank cells in Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Back
Top