Concat
Posted by Rudi Holans on February 05, 2002 1:00 PM
Hello,
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.
Rudi
Posted by John on February 05, 2002 2:00 PM
In B1 put:
=A1
in B2:
=B1&A2
and copy down.
