To quickly combine text and numbers from multiple cells in Excel, use the TEXTJOIN Excel function.
I’ll show you two examples, and you can scroll down to watch the video demo. Continue reading “Combine Excel Text with Conditions – TEXTJOIN Function”
Author: Debra Dalgleish
Pivot Table Not Sorting Correctly – Quick Fix
Usually, it’s easy to sort an Excel pivot table, but you might run into one that just won’t sort correctly! For example, employee names are listed alphabetically, but there’s a name at the top that doesn’t belong there. Why is the pivot table not sorting that one name with the others?
Continue reading “Pivot Table Not Sorting Correctly – Quick Fix”
Happy Excel Day 45678
Where does the time go? Two years ago, we were celebrating Excel Day 45000, and suddenly it’s Excel Day 45678!
Do you have any special events planned? If not, you could make the office festive, with a few balloons and a magic marker!
Debra’s Excel News–January 2025
Pin your Excel files, make decisions with a spreadsheet, and more, in this month’s Excel news. Visit my Excel website for more tips, tutorials and videos, and check the index for past issues of this newsletter.
Celebrate Days of Excel – Week of Jan 5 2025
There’s always something to celebrate, with several “Day of” events, for every day of the year! Here are events for the upcoming week, and I’ve found Excel templates and links for each of them!
Continue reading “Celebrate Days of Excel – Week of Jan 5 2025”
How to Split Date and Time in Excel
If your Excel sheet has a column with combined dates and times, you might want to separate date and time into different columns. My short video shows the steps, and there are written steps below.
Debra’s Excel News–December 2024
Fix a column header problem, QAT tips, and more, in this month’s Excel news. Visit my Excel website for more tips, tutorials and videos, and check the index for past issues of this newsletter.
Get This Excel Advent Calendar With No Macros
December is only 3 days away, so it’s time for an Excel Advent Calendar! I’ve made a new version this year, and it doesn’t use macros, just basic Excel features. Even if you don’t need an Advent calendar, take a look to see how the calendar is set up. It might give you ideas for other types of Excel projects.
Continue reading “Get This Excel Advent Calendar With No Macros”
Debra’s Excel News–November 2024
Fix pivot table errors, show images in cells, and more, in this month’s Excel news.
Visit my Excel website for more tips, tutorials and videos, and check the index for past issues of this newsletter.
Debra’s Excel News–October 2024
New PIVOTBY function, get ready for Spreadsheet Day, and more, in this month’s Excel news.
Visit my Excel website for more tips, tutorials and videos, and check the index for past issues of this newsletter.