How Split cells in excel | split one column into multiple columns using Flash fill in Excel | Bangla
You can split cells in Excel and split one column into multiple columns using the Flash Fill feature. Here's how to do it:
Open the Excel workbook and select the column that you want to split.
Insert a new column to the right of the column that you want to split.
In the first cell of the new column, type the first value of the split content that you want to extract. For example, if you want to split a name column into first and last names, type the first name in the first cell of the new column.
Press the "Enter" key to move to the next cell.
Type the next value of the split content that you want to extract. For example, if you want to split a name column into first and last names, type the last name in the second cell of the new column.
Select the first two cells of the new column that contain the split values.
Click on the "Flash Fill" button in the "Data" tab of the ribbon. Alternatively, press "Ctrl + E" to apply Flash Fill.
Excel will automatically fill in the rest of the column with the split values based on the pattern that you specified.
You can repeat the above steps for other columns that you want to split.
By following these steps, you can easily split cells in Excel and split one column into multiple columns using the Flash Fill feature. The Flash Fill feature is a quick and easy way to split data without using formulas or VBA. Note that the Flash Fill feature is available in Excel 2013 and later versions. You can find detailed guidance on using Flash Fill feature in Excel tutorials or videos available in different languages including Bengali (Bangla).