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 :


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?


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

Have a look at :-