CHAR Function Archives

How to Remove Spaces in Excel: With Formula, VBA & Power Query

Nov 30, 2021 Excel Formulas

In Microsoft Excel, there are several effective methods available to remove all sorts of unwanted spaces. You’ll get to know all possible and ...

How to Use SEQUENCE Function in Excel (16 Examples)

Nov 2, 2021 Excel Functions 2

In Microsoft Excel, the SEQUENCE function is used to generate a sequence of numeric values in different formats. In this article, you'll learn how ...

How to Use REPT Function in Excel (8 Suitable Examples)

Nov 11, 2021 Excel Functions

In Microsoft Excel, the REPT function is generally used to repeat a text or a character a defined number of times in a cell. In this article, you’ll ...

How to Split One Cell into Two in Excel (5 Useful Methods)

Nov 15, 2021 Advanced Excel

When you import data from a database or any other sources, you have to split cell one into two or more in such situations. In this tutorial, I’m ...

Excel Split Cell by Delimiter Formula

Oct 19, 2021 Advanced Excel

This tutorial will show you how to split cells with the help of a delimiter in Excel. A delimiter is a character that separates chunks of data within ...

How to Generate Random Numbers in Excel (9 Unique Methods)

Sep 13, 2021 Excel Formulas 4

Random numbers are those numbers that are generated by a process in which the outcome is not predictable and in a defined interval/set, the values ...