Hello,
Say I wanted to concatenate a row that had 10,000 values in it. How could this be achieved without having to click 10,000 cells while typing a comma in between each one?
Thanks.
Hello,
Say I wanted to concatenate a row that had 10,000 values in it. How could this be achieved without having to click 10,000 cells while typing a comma in between each one?
Thanks.
A B C 1A A B1: =A1 2B A,B B2: =B1 & "," & A2 3C A,B,C 4D A,B,C,D
Bear in mind that a cell can only contain 32K characters, and will only display about 1K.
Entia non sunt multiplicanda sine necessitate
Or someone else has written a nice UDF to do it for you
http://chandoo.org/wp/2008/05/28/how...-excel-concat/
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
Yes, Sktneer, I just stumbled across this one, too. It's amazing!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks