Automatically moving cells with data

[Closed]
Report
Posts
2
Registration date
Thursday October 9, 2014
Status
Member
Last seen
October 10, 2014
-
Posts
2
Registration date
Thursday October 9, 2014
Status
Member
Last seen
October 10, 2014
-
I have a column of times ie

A1 = 00:25
A2 = 00:32
A3 = Nothing or it could be 0 or #N/A
A4 = Nothing or it could be 0 or #N/A
A5 = 00:27

and so on.

I need to copy them to column B, but only the cells with times in eg

B1 = 00:25
B2 = 00:32
B3 = 00:27

So there are no gaps and all the null cells are deleted.

Can anyone help.

2 replies

Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
800
under what circumstances value in col A becomes #N/A unless it is a result of a formmula
Posts
2
Registration date
Thursday October 9, 2014
Status
Member
Last seen
October 10, 2014

It is the result of a formula, but I can set it to be #N/A or 0 or " "

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!