Allows us to enter data patterns to other cells.
In our previous post “10 Basic Excel Functions That Everyone Should Know” we learned how to use the =CONCATENATE() function. Concatenate merges data of different cells into one cell. What if I want to split the data of a cell into multiple cells or in other words how to reverse the concatenate function? For example, I […]