HDTutorial
EN

Playback starts YouTube’s embedded player (privacy-enhanced mode).

How To Generate True Blank Cells With A Formula In Excel

18,991 views November 15, 2016 6:41

Watch on YouTube
ChannelExcel Bytes

Description from the creator

Often in formulas in Excel, we use double quotes to indicate a blank. But in Excel, double quotes do not generate true blank cells. This tutorial will also show you a few other valuable tricks like converting text numbers to values, a quick way to convert formulas to values only, and how to delete rows with blanks.
To download the file and follow along, go to the link on my website at:

app.box.com/file/67027951505?s=w8wh7yl3aize46m0…

Do you need help with a formula or an Excel project?
You can send me an e-mail to [email protected]
Including a sample file is always helpful!

You can donate to my channel through any of the following:

PayPal:
paypal.me/ExcelBytes?locale.x=en_US

Zelle or Venmo:
Send to [email protected]

About this tutorial

Excel Bytes published this 6:41 video tutorial on November 15, 2016. It has been watched 18,991 times on YouTube.

Category
Education
Duration
6:41
Published
November 15, 2016
Views
18,991
Likes
101

Tags

Share

This tutorial in other languages