How to Split and Join Cells in Excel
€0.00
Free Excel file that presents three methods to split cells:
1. Flash Fill
2. Text to Columns
3. Formula using FIND, MID, LEN, and RIGHT
And four methods to join cells:
1. Flash Fill
2. CONCAT
3. TEXTJOIN
4. Use of the AMPERSAND sign (&)
Also check the video that showcases how to do it.