Automatically moving cells with data

Closed
SuttonRider
Posts
2
Registration date
Thursday October 9, 2014
Status
Member
Last seen
October 10, 2014
- Oct 9, 2014 at 02:00 PM
SuttonRider
Posts
2
Registration date
Thursday October 9, 2014
Status
Member
Last seen
October 10, 2014
- Oct 10, 2014 at 06:00 AM
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

venkat1926
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
805
Oct 10, 2014 at 05:49 AM
under what circumstances value in col A becomes #N/A unless it is a result of a formmula
0
SuttonRider
Posts
2
Registration date
Thursday October 9, 2014
Status
Member
Last seen
October 10, 2014

Oct 10, 2014 at 06:00 AM
It is the result of a formula, but I can set it to be #N/A or 0 or " "
0