Summary
This chapter covers string parsing and concatenation techniques, including splitting text by delimiters or fixed positions, combining text values, and extracting date components.

General domain of usage
Data preprocessing

### Text to Columns — Delimiter Mode
When values are crammed into one cell separated by a consistent character — a comma, space, dash, pipe — **Text to Columns** is the right tool. It splits the source cell into as many columns as there are segments, using the separator as the cut point.

How the split works visually — the delimiter marks every cut:</br>
`55,John Doe,John,Doe,01/03/2026,Tablet,1,200,,Paid`
1. Select the source range → **Data tab** → **Text to Columns** → choose **Delimited** → **Next**;
2. Check the delimiter character (comma, space, tab, or custom) → preview updates in real time → **Next**;
3. Optionally set the data type for each resulting column (Text, Date, General) → **Finish**;




### Text to Columns — Fixed Width
A **Text to Columns** mode where you drag vertical break lines in a preview to define column boundaries by character position, not by a separator character. The data structure must be visually consistent — each field occupies the same number of characters in every row.

### The & Operator
The ampersand is Excel's text glue. It joins any combination of cell references, literal text strings (in quotes), and function results into a single value.</br>
`=C2 & D2 & "@email.com"` →
`EmilyJohnson@email.com`


Learn Excel the fun way — step by step, you'll go from basic data handling to building charts and dashboards that actually make sense. You'll learn how to organize messy data, use formulas with confidence, and turn numbers into clear insights.


Messy spreadsheets turn into clean, structured data. Tables, sorting, filtering, and smart input rules help keep everything accurate and easy to work with.

Raw data becomes clear and readable. Formatting, alignment, and conditional highlights make important insights stand out instantly.

Numbers start working for you. Formulas, functions, and logical conditions handle calculations, automate tasks, and solve real problems.

Data turns into visuals that tell a story. Charts, sparklines, and design improvements make information easy to understand at a glance.

Big datasets become simple summaries. PivotTables, interactive controls, and dashboards bring everything together into clear, dynamic insights.

Fast Data Shaping

Text to Columns — Delimiter Mode

Text to Columns — Fixed Width

The & Operator