Excel Functions

How to extract after a specific character "RIGHT function and FIND function" Excel (Excel)

As shown in the figure below, when the data to be extracted is contained after a string and the number of characters of the data to be extracted is not constant, the RIGHT function alone cannot be used to extract the data. Function to extract the data after the "¥" mark in cell "A2" = RIGHT(A2,LEN(A2)-FIN...)

2025.02.18 2025.02.19

Excel Functions

How to extract characters before a specific character "LEFT and FIND functions" Excel (Excel)

As shown in the figure below, if there is extra data after the string and you want to extract only the string to the left of the extra data, you cannot simply use the LEFT function alone because the number of characters is not constant. Function to extract the left side of the "¥" mark in cell "A2" = LEFT(A2,FIND(...))

2025.02.18 2025.02.19

Excel Functions

Excel Macro (VBA): How to use the CountIfs function in VBA!

If you are a beginner who wants to use Excel's COUNTIFS function in VBA, this is a must. This article provides a thorough explanation from basic writing to error handling. In fact, with a few tricks, you can reduce processing time from a few minutes to a few seconds. Read this article and you will be able to efficiently tabulate data from tomorrow.

2025.02.10 2025.02.12

Excel Macro (VBA)

3 ways to show/hide "0" in calculation results Excel (Excel)

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.26 2024.10.29

Excel Functions

For beginners] Explanation of causes of Excel being slow and countermeasures.

Manager, have you ever felt 'kind of heavy' when using Excel? Student Yes, sir! I recently started using Excel to improve my business, but I'm having trouble opening files because it takes so long. ManagerYes, that's right. Many people have the same problem...

2024.10.01 2024.10.02

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.18 2024.09.22

Excel Functions

SUBSTITUTE function" Excel, a method to convert numbers in addresses to Chinese numerals in one shot.

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.17 2024.09.20

Excel Functions

VLOOKUP function gives #N/A or #REF!

The VLOOKUP function is a very useful function for handling data, but many of you may have experienced that once you get stuck in the error swamp of #N/A or #REF! In this article, we will discuss how to use the VLOOKUP function to get rid of the #N/A and #REF!

2024.07.05

Excel Functions

Insert rows without breaking formulas (using spil) Excel (Excel)

With Microsoft365 and Excel 2021 or later versions, you can insert, delete, and rearrange rows without breaking the formula by using a feature called Spill. In this article, we will show you a specific example...

2024.07.04 2024.09.13

Excel Functions

How to use the Spill function Excel (Excel)

I had neglected the "spill" feature implemented in Microsoft365 and Excel2021 for a while because I didn't really understand it, but when I tried it, I found it to be very useful. I found it to be very useful. Moreover, I thought that I could do a lot of things by applying this function...

2024.07.04

Excel Functions