How to split numbers into multiple columns in Excel? - Excel Tips and Tricks

Learn how to split numbers into multiple columns in Excel. With this video, you will also know how to split data in one column into multiple columns. In other words, how do you split a cell data into two columns? Or how do I separate 4 digit numbers in Excel?

This is a formula I use in my video.

Split Into Separate Columns
=MID(TEXT($B4,"????????"),COLUMN(A1),1)

#shorts #short #shortvideo #fyp #excel #microsoft #tiktok #fypシ