In this video you’ll learn several ways you can change case of your records in Excel spreadsheets. We’ll look at a special tool that allows you to capitalize the first character in each cell or update the selected values to uppercase, lowercase, or proper case; we’ll learn the standard Excel functions we can use, and see how we can employ Flash Fill in Excel. Continue reading
Learn how to trim leading and trailing spaces, delete all blanks between numbers, and remove extra spaces between cell values in Excel using standard functions or a special add-in. Continue reading
Ultimate Suite has become even better. We improved Consolidate Worksheets Wizard and Remove Characters, added the Clear Formatting, Split Text, Add Text add-ins and re-implemented Column Manager. Read this article to learn more. Continue reading
This video will show four different solutions for merging rows of data, blocks of rows, or duplicate records from different lines in your table. Learn what formulas and tools you can use to combine rows in Excel and keep all important information intact. Continue reading
We often need to combine columns in Excel to get names, addresses, and similar records in one cell. As there are no built-in tools for merging values from multiple columns, see three ways you can go in this video. Continue reading
We have introduced some exciting changes to one of our best time-savers. This video will show you how Merge Tables Wizard can quickly and efficiently combine data from two Excel files. No formulas, no redundant work, just 6 simple steps to get the job done. Continue reading
The worldwide release of Office 2016 caused a lot of buzz among Microsoft users. So have we been moving full steam ahead to announce Ultimate Suite support for the latest version of Excel. Continue reading
Since Microsoft released Excel 2016 and Windows 10 Preview, we have been in a hurry to support them. Thus we are happy to report that we have just released an update of our flagship product Ultimate Suite for Microsoft Excel. … Continue reading
What a beginning of the year it was! Not sure about you but I feel like the year is already flying by. Last week we officially finished the BETA version of new Merge Tables Wizard (whew!). So I'll take some time to kick my feet up while waiting for your feedback. Continue reading
The tutorial provides a variety of advanced IF formula examples that demonstrate how to use the Excel IF function with other functions, make nested IF formulas with multiple conditions, use IFERROR and IFNA. Continue reading
Our summer has been busy with developing 3 new tools for Ultimate Suite and with fixing some major and minor bugs. Now you can try the new add-ins for swapping, flipping, and transposing columns, rows, and cells in your table. Continue reading
We added 3 new tools to Ultimate Suite for Excel. They are Count and Sum by Color, Unpivot Table and Create Cards. Read on to learn how you can calculate cells by color, flatten your summary tables, and convert your data into label cards. Continue reading
In this article I'll show you 3 ways how you can add hyperlinks into your Excel workbook to easily navigate between numerous worksheets. You'll also learn how to change a link destination and modify its format. If you don't need a hyperlink any more, you'll see how to quickly remove it. Continue reading
For the last 6 months we have been working on a new version of Ultimate Suite that includes 20 helpful add-ins for Excel. We tried to get the most out of Excel to achieve our main goal: speeding up Ultimate Suite for you to get really quick results with less time and energy invested! Continue reading
Change of the seasons is my favourite time for letting you know about the improvements we bring to Ultimate Suite. Here at AbleBits we’ve been testing and enhancing the tools you use daily. Today, we’re making the updates available to you! Continue reading
Watch our 2 minute video to learn how you can quickly merge duplicate rows into one using Combine Rows Wizard add-in. Continue reading
There is a lot of different software around us. Some of it really simplifies life, and some of it just doesn't. I want our Suite to fall under the first category. As this year started, I began collecting all the feedback our customers send to us to understand how we can make Ultimate Suite your reliable assistant in Excel... Continue reading
Are you always the first to try new stuff? Here's something you'll like: all our add-ins support Microsoft Office 2013 starting today! Continue reading
If you already moved to Office 2013 and miss Trim Spaces in your Excel, follow simple steps to regain the tool for finding and removing leading and trailing spaces in your worksheets... Continue reading
Lots of Excel users like Ablebits Add-ins Collection for its ability to speed up many tedious and time-consuming tasks they perform daily in Excel. There’s no limit to perfection, so our developers have been working hard on the collection optimization and finally introduced some really dramatic changes... Continue reading