Reversing Text to Columns in Excel/Calc
Most Spreadsheet Software I've Used Has a Text-to-Columns Function That Splits a Single Column into Multiple Columns Using Several Criteria (Delimiter, # of...
Most spreadsheet software I've used has a text-to-columns function that splits a single column into multiple columns using several criteria (delimiter, # of character, etc). I want to do this in reverse.
I know I can use a formula to create a third column with the values of the two cells concatenated together with a delimiter between them but this seems clunky.
Why is this not a built in function? Or is it there somewhere that I can't see?
2 Answers
There are built-in functions that will allow you to combine multiple cells into one with a delimiter between each.
Let's say you want to join cells A1 to A5 with a , in between each value.
Must Read
Excel 2016
=TEXTJOIN(",",TRUE,A1:A5)
Maya is a hardware enthusiast who tests and reviews smart home devices, smartphones, wearables, and audio gear. She focuses on practical consumer value and build quality.
