Скачать или смотреть Excel - Split text to a vertical list using my REVERSE Concatenate formula

Most people have heard of the concatenate formula in Excel that combines a number of cells in to one cell. BUT, what if you wanted to reverse this process create a list by splitting one cell. This can be done in what I call the 'Reverse Concatenate' formula.
It combines functions already availabe in Excel to allow the user to split cells, using a delimiter of their choice, and creating a list. It will also show you how to use this formula, and keep the original delimiter.

Check out some other easy to follow Excel formula videos in the Playlists below:

Other playlists:

PIVOT TABLES:
   • How to change date formats in Pivot Tables  

EVERYTHING about the FILTER FUNCTION:
   • EXCEL Filter Rows & Columns  

EXTRACT first word, 2nd word, last word, numbers, letters:
   • Extract the numbers from a Cell in Excel -...  

2 MINUTE Formula:
   • Excel If formula - If CONTAINS formula in ...  

#excel
#excelformula
#concatenate
#reverseconcatenate