what's wrong with this formula??
Posted by JO on February 22, 2001 2:15 AM
I am trying to concatenate a range of 30 rows using this formula :
=CONCATENATE(C6:C20)
but it just won't work!! It either comes back with #VALUE or it only pastes the first line in. As there are a number of rows I don't want to have to enter
=CONCATENATE(C6,C7,C8,C9....)etc as it will take forever. Does anyone know of a quicker way?
Cheers!
jo
