MrExcel Publishing
Your One Stop for Excel Tips & Solutions


Posted by Rudi Holans on February 05, 2002 1:00 PM

In cell A1 to A5 i have text values. I want to concat all values to 1 value. How can I do this quickly without using this function: =A1&A2&A3&A4&A5

Not very practical if you have hundreds of rows to concat.

Many thanks for your help.


Posted by John on February 05, 2002 2:00 PM

In B1 put:

in B2:

and copy down.