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 👉 [email protected]
📊 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
-
17:23
Russell Brand
1 day agoThey couldn't handle this...
90.1K261 -
18:18
DeVory Darkins
18 hours ago $28.24 earnedPortland gets NIGHTMARE NEWS as Trump orders Troops to crush violent rioters
34.8K265 -
TonYGaMinG
4 hours ago⚔ Trying out this NEW game called " SWORN " ⚔
30.4K4 -
LIVE
Lofi Girl
2 years agoSynthwave Radio 🌌 - beats to chill/game to
206 watching -
29:27
James Klüg
1 day agoAmericans Remembering Charlie Kirk
28.3K6 -
9:36:11
GoA_Malgus
11 hours ago $0.31 earnedGoA Malgus - The Legend Has Returned!!! - Live domination on Black Ops 6
19.5K1 -
48:15
SouthernbelleReacts
1 day ago $9.95 earnedWeapons (2025) REACTION | Josh Brolin, Julia Garner, Alden Ehrenreich | Horror-Mystery Thriller
54.3K33 -
39:36
mizery
4 days ago $1.17 earnedI Mastered Fortnite in 30 Days
33K6 -
25:50
ChopstickTravel
18 days ago $4.83 earned24 Hours With Sri Lanka’s Vedda People!! (Barehand Honey Harvest)
51.5K10 -
8:13
Danny Rayes
1 day ago $3.45 earnedMost Hated Teacher on Tiktok
32.3K27