-
Recent Excel Posts
- How to Find and Use a Grocery List Template in Excel 365
- How to Find and Use a Summer Activity Calendar Template in Excel 365
- How to Find and Use a Profit and Loss Statement Template in Excel 365
- How to Find and Use a Trip Planner Template in Excel 365
- How to Use the Excel QR Code Generator in Excel 365 (Step-by-Step Guide)
-
Recent Comments
-
Excel Tips Blog
- Google Spreadsheets vs Excel Online: Which Web-Based Spreadsheet Is Better for Everyday Work?
- Excel Data Validation Rules: Stop Bad Inputs Before They Break Your Formulas or Dashboards
- Excel vs Google Sheets for Students: Choosing the Right Tool for Assignments, Group Projects, and Data Courses
- Excel Named Ranges: How to Make Complex Spreadsheet Equations Easier to Read, Debug, and Reuse
- Excel Power Query for Data Cleaning: Turn Messy CSVs and Logs into Analysis-Ready Tables Without Manual Editing
Tag Archives: excel formula tips
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