ReBizRU

3 Easy Ways to Hide or Show Zero Values in Excel: Simple Formatting Tips

As shown in the figure below, when "A1" cell contains 150 and "A2" cell also contains the same number, 150, the calculation result of "=A1-A2" is "0" zero. There are three ways to avoid displaying numbers when the result of the calculation is "0" zero. The result of the calculation is "0" zero...

2024.10.29

Excel Functions

How to Extract Text After a Specific Character in Excel Using RIGHT and FIND

Struggling to extract text after a specific character in Excel when data lengths vary? This article explains how to combine the RIGHT and FIND functions to solve the problem—taught by an experienced Excel formula expert.

2025.06.18

Excel Functions

How to Instantly Convert Address Numbers to Kanji Using SUBSTITUTE in Excel.

When printing addresses on envelopes using the address list of a New Year's card or a customer list, for example, horizontal envelopes are written in arithmetic (Arabic) numerals such as "1, 2, 3", while vertical envelopes must be written in Chinese numerals such as "1, 2, 3". Substitute the numbers...

2024.09.20

Excel Functions

Easy with Excel and Word! Mastering the art of address printing that anyone can do!

Have you ever had to worry about writing addresses for New Year's cards and summer greeting cards? Writing dozens of cards by hand is a lot of work, but buying specialized software is also a bit expensive.... Everyone has experienced this dilemma at least once. But the truth is, your computer...

2024.09.22

Excel Functions

Specific ways to present Excel skills that are useful in job interviews.

You use Excel in your daily work. But are those skills that allow you to say, "I'm good at Excel," really applicable in the job market? Many of us learn the basics of Excel in new employee training and use it in our daily work. Sure, we enter formulas, create graphs...

2024.09.29

change of occupation

How to set up read-only and password Excel (Excel)

Here is how to set Excel to read-only or set a password when opening. Display the General Options screen First, display the "Save As" screen. On the Excel screen, click the "File" tab, then click "Save As," then click "...

2024.01.10

Excel Functions

What does the error message "#VALUE!" mean and what can I do about it?

Error messages are unavoidable when dealing with Excel, and you may be surprised when they suddenly appear. Here are the meanings and countermeasures for these errors. As an example of preconditions, let's make a table like this...

2024.05.30

Excel Functions

How to Insert Rows in Excel Without Breaking Formulas

Having trouble with broken formulas after inserting rows in Excel? This article explains step-by-step how to fix them easily using formula copying—shared by an experienced Excel expert.

2025.06.18

Excel Functions

Automatically create invoices from sales invoices1 Excel (Excel)

There are many useful software systems that automatically output invoices as you record sales data if you pay for them, but many people are unable to install software because they "don't have enough money to pay for it" or "management won't allow it" and are making each invoice by hand...

2024.06.10

Excel FunctionsLet's make an invoice from a sales invoice.

About Variable Types Excel(Excel) Macro(VBA)

This section explains the types used when declaring variables in "Dim Variables". Here are some typical types of variables that you only need to remember. I almost always use only these. Variable typeThe range of data that can be storedstring stringlong integer (-2,14...)

2024.06.14

Excel Macro (VBA)