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

=CONCATENATE(I4,J4,K4)

or

=I4&J4&K4