-
Recent Excel Posts
-
Recent Comments
-
Excel Tips Blog
- GROUPBY and PIVOTBY in Excel: Build Dynamic Reports Without PivotTables (2026 Hands-On Guide)
- How to Fix Excel Formulas That Return Errors: The Most Common Causes and Solutions
- Custom Cursor Tools for Excel and Google Sheets: Apps, Extensions, and Settings to Make Point-and-Click Work Faster
- Excel Tutorial for 2026: A Step-by-Step Guided Project to Learn Core Features in One Weekend
- Spreadsheet Equations Explained: How to Turn Real-World Problems into Formulas in Excel
Tag Archives: excel text functions
Excel Text Functions: How to Extract, Combine, and Clean Text
Last updated: July 14, 2026 Quick Answer: Excel text functions let you pull out parts of a string, join values from multiple cells, and scrub messy data, all without touching each cell by hand. Functions like LEFT, RIGHT, MID, TRIM, … Continue reading
Posted in Excel Tips Blog
Tagged clean data excel, concatenate vs textjoin, excel formula tips, excel text functions, extract text excel, mid function excel, substitute function, text string manipulation, textbefore textafter excel, trim function excel
Comments Off on Excel Text Functions: How to Extract, Combine, and Clean Text
how to combine two columns in excel
Last updated: July 4, 2026 Quick Answer: To combine two columns in Excel, use the ampersand operator in a new column, for example, =A2&” “&B2 joins the values from cells A2 and B2 with a space between them. You can … Continue reading
Posted in Excel Tips Blog
Tagged combine columns without losing data, excel ampersand operator, excel combine columns with space, excel concat function, excel concatenate formula, excel formula tips, excel text functions, flash fill excel, how to combine two columns in excel, merge columns excel, microsoft excel tips, textjoin excel
Comments Off on how to combine two columns in excel