Mar 10 2022 12:13 PM
I have a range of entries say a1:a5 that contains A, B, C, D, E, respectively. I want to write a functions that essentially says, in cell c1 If a1 is not empty then copy a1:a5 to else " ". Any suggestions?
Mar 10 2022 01:13 PM