Previous Topic Next Topic

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 responses

Answer 1 / 2
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
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
Answer 2 / 2
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 " "

Similar discussions

help me to add particular cells
mathewmunna -
mathew munna -

2 responses
Hosted app data will not clear
Woody_3336 -
woody_3336 -

7 responses
How To Fix Mint Mobile Data Not Working?
sachin327 -
joshitha -

2 responses
Why does our account keep randomly following additional users every few weeks?
Coach -
ElenaKM -

1 response
Unlock safe folder without losing any data
Mintu -
HelpiOS -

1 response