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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Very strange behaviour of VLOOKUP in Excel 2010 4
Averageifs - criteria is cell is not blank 1
find oldest date with a condition 4
how to return "summary" of all non-blank cells plus their headers 10
Excel Concatenate with line breaks but ignore blank cells 3
Excel Concatenate addresses in Excel but avoiding blanks, and line breaks 6
Average Question 2
Excel formula, sum the value cell and if empty cell left blank 0

Back
Top