Excel tutorials, functions and advanced formula examples

How to convert table to a normal range in Excel and turn data range into a table

Table is one of the most useful things in Excel that makes managing, calculating and updating data a lot easier. Under certain circumstances, however, a table format may not suite your needs. This short tutorial will teach you how to turn a table into a normal range without losing your data. Continue reading

How to remove characters/text from string in Excel

In this tutorial, we will look at the most common cases of removing characters in Excel. Want to delete specific text from multiple cells? Or maybe strip the first or last character in a string? Or perhaps remove only a specific occurrence of a given character? Whatever your task is, you will find more than one solution for it! Continue reading

How to remove special (unwanted) characters from string in Excel

When importing data to Excel from somewhere else, a whole lot of special characters may appear in your worksheets. Even more frustrating is that some characters are invisible, which produces extra white space before, after or inside text strings. Continue reading

Video: How to count colored cells in Google Sheets

If you haven't tried our Function by Color add-on for Google Sheets yet, you will be pleasantly surprised. It calculates values based on their font, fill, or both colors using 13 aggregation functions. Today's video will show you how it works. Continue reading

How to view shared files in OneDrive and stop sharing

OneDrive is a perfect place for sharing your files and collaborating with your colleagues. After someone has shared something with you, the next question is - where do I find those files? Continue reading

How to delete text before or after a certain character in Excel

In the recent couple of articles, we've looked at different ways to remove characters from strings in Excel. Today, we'll investigate one more use case - how to delete everything before or after a specific character. Continue reading

How to remove first (left) or last (right) characters in Excel

When working with unstructured text data, you often need to parse it to retrieve relevant information. This article will teach you a few simple ways to remove any number of characters from the left or right side of a text string. Continue reading

How to share files securely with OneDrive

There are a few different ways to share documents on OneDrive, and you may be asking yourself which is the best one. For the most part, the answer depends on the situation and your ultimate goals. But I can show you the most secure way. Continue reading

How to share OneDrive files and folders

Like most other online storages, OneDrive was designed with collaboration in mind, and they strived to make the sharing process easy and intuitive. However, there are some caveats to take notice of, especially when adding and syncing shared files to your computer. Continue reading

Find and replace special characters in Google Sheets

Getting tired of all those smart quotes, accented letters, and other unwanted special characters in Google Sheets? We have a few ideas on how to replace them effortlessly. Continue reading

How to remove text and leave numbers in Excel or vice versa

Imagine this: you receive raw data for analysis and find out that numbers are mixed with text in one column. In most cases, it will certainly be more convenient to have them in separate columns for closer examination. Continue reading

Video: remove the same characters and substrings from multiple Google Sheets cells

Today's video is all about getting rid of unwanted text from several Google Sheets cells at once. You'll see how our Remove Text add-on removes specific characters and various substrings from different positions in cells. Continue reading

How to remove table formatting in Excel

By default, Excel tables are equipped with a number of great features including predefined table styles. In some situations, however, you may want to remove formatting keeping all other functionality of a table. This tutorial will teach you how to quickly do that. Continue reading

Extract data from Google Sheets cells: text, numbers, URLs, hyperlinks, email addresses, dates, and time

This next bit of our operations with text in spreadsheets is devoted to extraction. Find out ways to extract various data – text, characters, numbers, URLs, email addresses, date & time, etc. – from various positions in multiple Google Sheets cells at once. Continue reading

How to highlight duplicate text strings or words in Excel cell

Excel Conditional Formatting makes it possible to highlight duplicates in every possible way you can think of. But, as usual, there is a "but" - conditional formatting rules work on a cell level while you may want to highlight duplicate text rather than entire cells. This can only be done with macros. Continue reading

How to find and replace multiple values at once in Excel (bulk replace)

How do people usually search in Excel? Mostly, by using the Find & Replace tool, which works just fine for single values. But what if you have tens or even hundreds of items to replace? Luckily, there are a few more effective methods to perform mass replace in Excel, and we are going to look at each of them in detail. Continue reading

Outlook email templates: 10 ways to quickly reply to repetitive emails

If a major part of your online communication is repetitive emails, it would be only natural that you strive to optimize that part of your work. Replying with template can be a great alternative to composing emails from scratch in a tedious keystroke-by-keystroke way. Continue reading

Video: how to add text to multiple Google Sheets cells

We have plenty of useful add-ons to manage text in spreadsheets. Add Text is one of them. Watch today's video to learn how to insert the same text to multiple Google Sheets cells: at the beginning & at the end of cells, after the Nth character, before/after a certain text string. Continue reading

How to write recursive LAMBDA function in Excel with examples

With the introduction of the LAMBDA function, recursive computations in Excel have become available to anyone, not just VBA programmers. To put it simply, you can now construct formulas that behave like a programming language and allow you to achieve so much, with so little, so fast :) Continue reading

Excel LAMBDA function: how to write and use

Until recently, user-defined functions were the prerogative of programmers. The introduction of the LAMBDA function has made them available for everyone. With this wonderful addition to Excel's toolbox, we no longer need VBA skills to create our own custom functions. Continue reading