MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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


Posted by Celia on February 22, 2001 4:13 AM


Have a look at :-
10581.html