13. How to do Split cells in excel | split one column into multiple columns in Excel | Power Query
In Microsoft Excel, you can split the contents of a single cell into multiple cells or columns using the Text to Columns feature or Power Query.
Here's how to use the Text to Columns feature to split cells in Excel:
Select the cells that you want to split.
Go to the "Data" tab in the Excel ribbon, and click the "Text to Columns" button in the "Data Tools" group.
In the "Text to Columns" wizard, select the "Delimited" option, and click the "Next" button.
In the "Delimiters" section, select the delimiter that separates the data you want to split (e.g., a comma, space, or tab).
Make sure the other delimiter options are not selected, and click the "Next" button.
In the "Destination" section, select the cell in the destination column where you want the split data to start, or click the "New Worksheet" button to create a new sheet for the split data.
Click the "Finish" button to split the cells.
Your cells will now be split into separate columns, with each column containing the data separated by the specified delimiter.
Here's how to use Power Query to split cells in Excel:
Go to the "Data" tab in the Excel ribbon, and click the "From Table/Range" button in the "Get & Transform Data" group.
In the Power Query Editor, select the range of cells that contains the cell you want to split.
In the "Home" tab in the Power Query Editor ribbon, click the "Split Column" button in the "Transform" group.
In the "Split Column" dialog box, select the column you want to split, and choose the delimiter that separates the data you want to split (e.g., a comma, space, or tab).
Click the "OK" button to close the dialog box.
In the Power Query Editor, click the "Close & Load" button to load the split data back into Excel.
Your cell will now be split into separate columns, with each column containing the data separated by the specified delimiter.
Learn About Below Topic Content In This Channel
01) Microsoft Visual Basic ( Excel VBA, Macro)
02) Microsoft Excel Tutorial In Bangla
03) Microsoft Word Tutorial In Bangla
04) Microsoft Powerpoint Tutorial In Bangla
05) Computer Tips And Tricks In Bangla
COMMUNICATE WITH HASAN ACADEMY
[email protected]
#HasanAcademy #Power_Query #Power_Query_Bangla
Facebook page
/ hasanacademybanglatutorial
Subscribe link : / @hasanacademy779
Facebook group link : / 282270382269650
Facebook page link : / hasanacademybanglatutorial
Most popular video Link :
• Excel VBA Bangla Tutorial 48 : Data Entry ... • Excel VBA Bangla Tutorial 50 : Create Add ... • Excel tutorial Bangla 24 : Top 10 Used For... • Excel VBA Bangla Tutorial 54: Add- Employe... • Introduction to Pivot Tables-Charts-and-Da... • Excel VBA Bangla Tutorial 49 : Invoice | B...
Most of the people is think about that how I will learn .But they didn't get any idea & trustworthy source. Don't hesitated Hasan Academy with you. You will learn from here, Excel, Excel Chart, Pivot Table, Vlookup, Formula function