MrExcel Publishing
Your One Stop for Excel Tips & Solutions

help using concatenate to add text from different cells together

Posted by alexis on February 05, 2001 8:33 AM

I have a user calling that needs to add the text from several different cells together. i thought of using concatenate to do so. first went to each row and formatted them as text and then went to last and inserted the formula concatenate(i4:k4) but got the value of #VALUE! instead. please help. thanks.

Posted by Mark W. on February 05, 2001 9:04 AM