Premium Only Content

When to use text to column in excel | Excel Practice Case #15 إتعلم حيل إكسل مع دكسلو 🇹🇳
When to use text to column in excel | Excel Practice Case #15 إتعلم حيل إكسل مع دكسلو 🇹🇳
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
In this video we explore the use of the text to columns command in Excel to convert CSV values into columns.
When data is imported into Excel it can be in many formats depending on the source application that has provided it.
For example, it could contain names and addresses of customers or employees, but this all ends up as a continuous text string in one column of the worksheet, instead of being separated out into individual columns e.g. name, street, city.
You can split the data by using a common delimiter character. A delimiter character is usually a comma, tab, space, or semi-colon. This character separates each chunk of data within the text string.
A big advantage of using a delimiter character is that it does not rely on fixed widths within the text. The delimiter indicates exactly where to split the text.
You may need to split the data because you may want to sort the data using a certain part of the address or to be able to filter on a particular component. If the data is used in a pivot table, you may need to have the name and address as different fields within it.
This Excel functionality Text-to-columns can be used to split text in a cell into sections based on a delimiter character.
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
╔═╦╗╔╦╗╔═╦═╦╦╦╦╗╔═╗
║╚╣║║║╚╣╚╣╔╣╔╣║╚╣═╣
╠╗║╚╝║║╠╗║╚╣║║║║║═╣
╚═╩══╩═╩═╩═╩╝╚╩═╩═╝
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
🙋🏼♂️ PLEASE SUBSCRIBE
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
✅ SUBSCRIBE HERE 👉 https://bit.ly/3cQUVZZ
🆓 DOWNLOAD the Exercise file and solution for this video here 👉
SUPPORT THE CHANNEL
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
👉Teespring Merch&Books 👉 https://bit.ly/3S1fa7n
Social Media / Contact us
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
🤳Dexcelo on TikTok 👉 https://bit.ly/3JgslNU
📥 Business Inquiries 👉 dexcelo03@gmail.com
📊 In this course you will learn how to:
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
- Understand the CSV values which stands for a comma-separated values (CSV) file is a delimited text -file that uses a comma to separate values.
- Use the CTRL + Shift + Down arrow to highlight the whole CSV Data
- Use the text-to-column command under data tab, data tools group
- Use ALT + A + E shortcut to open text-to-column
- Set the parameters in the text-to-column window that best describes your data
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
✏️ Course developed by Dexcelo.
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
⭐️ APPROXIMATE CONTENT TIMESTAMPS ⭐️
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
0:00:00 - 0:02:00 Intro & Objectives
0:02:00 - 0:03:30 Finding the Text to Columns command
0:03:30 - 0:11:07 Understanding the Text to Columns wizard
0:11:07 - 0:11:51 Applying the Text to columns
0:11:51 - 0:13:38 Objectives Summary
🔗 Useful Links
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
⚈ Microsoft Excel Help Center https://bit.ly/3Q99vu8
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Thank you for your support 🙏🙏🙏 !!!
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Tags
#excel #اكسل #learnexcel #excelshortcuts #exceltips #shortcuts #microsoftexcel #microsoft #exceltutorial
-
1:20:15
vivafrei
2 hours agoRFK Jr. Takes on the Pharma WHOORES! Toddler-Assaulter Granted BAIL? COMPLYE WITH CRIMINALS! & more
35.7K20 -
LIVE
LadyDesireeMusic
1 hour agoLive Piano Request - Anti Brain Rot - Support Culture Shift
169 watching -
LIVE
The HotSeat
1 hour agoTrump’s Parade = Mocked, China’s Parade = Praised: Leftist Hypocrisy EXPOSED
611 watching -
1:57:29
The Quartering
2 hours agoRFK Jr Goes NUCLEAR, Horrible Tomb Raider News, Anti-White Male Propaganda
70.2K17 -
LIVE
Dr Disrespect
5 hours ago🔴LIVE: Hell Is Us Launch - DR DISRESPECT’s First Look at the Scariest Game of 2025!
1,324 watching -
LIVE
Pop Culture Crisis
2 hours agoSabrina Carpenter Wants Feminist Approval, Demonic Rituals at Burning Man? | Ep. 910
354 watching -
11:17
Dr. Nick Zyrowski
29 days agoTop 10 No CARB No SUGAR Foods That Will Change Your Health
9.51K4 -
LIVE
Chrissie Mayr
2 days agoChrissie Mayr's Content Hotel at The Villa Roma! Anthony Cumia, Dave Landau, Violet
59 watching -
LIVE
The Nunn Report - w/ Dan Nunn
1 hour ago[Ep 741] RFK Jr. Hits Back at Rabid Dems | Portland Antifa Terrorists | The Evil That is the Left
163 watching -
1:52:45
John Burk
3 hours agoThe Texas Hemp ban, DOJ removing guns from trans, and more.
6.4K3