How to split text into columns in Excel (Delimiting/Opposite of concatenation) in Mac

Опубликовано: 03 Октябрь 2024
на канале: Lets Excel
3,473
30

In this video, I am using text to columns button inside data tab to split two different types of data, delimited and non-delimited.


Please support by subscribing to my channel. 🙏🙏🙏
Subscribe:    / @letsexcel9476  

Here are links to my other Excel videos:
How to add UCL and LCL in Excel:    • How to add UCL and LCL in excel chart  

How to add a trendline in Excel:    • How to add a trendline in Excel  

Excel shortcuts keys for MAC | Top 10:    • Excel shortcuts keys for MAC | Top 10  

Using freeze pane in Excel in 3 minutes:    • Using freeze pane in Excel in 3 minutes  

Concatenate in Excel:    • How to concatenate in Excel (Mac)  

T-test using Excel:    • t test using excel  

How to use if function in Excel:    • How to use if function in Excel  

Calculating date difference in Excel:    • Calculating date difference in Excel  

How to create pivot table:    • How to create pivot table  

How to round in Excel:    • How to round in Excel  

How to calculate age in Excel:    • How to calculate age in Excel using t...  

How to create table in Excel:    • How to create table in Excel  

How to create macros in Excel:    • How to create macros in Excel (Mac)  

How to perform Chi-square test in Excel:    • How to perform Chi-square test using ...  

Here is link to modeling database using MySQL Workbench:    • How to model database using MySQL Wor...  





#Excel #Exceltutorial #MSExcel