Bulk Concatenation with separator
Hi, I have a long list of values in columns, I would like to concatenate the list (without manually selecting each value) and insert a semi colon between each value eg cell A1 (1113159), cell B1 (H13159), cell C1 (WD 12 X (UK)). I would like the output to look like this : D1 1113159;H13159;WD 12 X (UK)
Try this in D1 and copy down:
=A1 &";" & B1 &";" & C1
Ted
"Live Long and Prosper"
Hi, thanks for this, but I have 100 columns that need concatenating, and I do not want to have to manually select each column to put in the formula. See attachmentBulk Concatenation.xlsx
if you just want a ; delimited list
copy past unformatted text into word
find /replace find ^t replace ; you can copy back into excel
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Try this UDF from snb:
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks