CHAR Function Archives

Find and Replace Tab Character in Excel (2 Suitable Ways)

Aug 7, 2022 Excel Basics

Tab character plays a vital role in Excel usage. With this character, we can quickly create four spaces in one hit. But, during data analysis and ...

How to Add Trend Arrows in Excel (3 Suitable Ways)

Aug 7, 2022 Excel Basics

This article illustrates how to add trend arrows in excel. Trend arrows are commonly used all over the world, especially in stock market statistics. ...

How to Make a List of Special Characters in Excel (3 Easy Ways)

Aug 6, 2022 Excel Formulas

Whenever you are working with Excel, at some point you will need to use some special characters in your Excel sheet. The main objective of this ...

Up and Down Arrows in Excel Using Conditional Formatting

Aug 7, 2022 Excel Basics

Having up and down arrows in proper places of datasets makes them more presentable and visually pleasing. It is one of the features Microsoft Excel ...

Character Code for Check Mark in Excel (2 Applications)

Aug 4, 2022 Excel Basics

A tick mark or checkmark is a symbol inserted into a cell to confirm something or show that something is applicable. If you are looking for special ...

How to Add Double Quotes and Comma in Excel with CONCATENATE

Aug 1, 2022 Excel Basics

Adding double quotes, commas, or any other special characters to some cells in Excel is a frequent need for Excel users. It is tiring and ...

Add Multiple Bullet Points in Excel Cell (5 Suitable Ways)

Jul 18, 2022 Excel Basics

Bullet points are very common in MS Word. But in Excel, we do not have any built-in option to insert bullet points. It is very tricky to insert ...

How to Insert Degree Symbol in Excel (6 Suitable Methods)

Jul 3, 2022 Excel Basics

The Degree (°) symbol is used in Trigonometry. It denotes the angle. But there is no single dedicated button on the keyboard so that we can directly ...

How to Remove Sign in Excel (With 3 Examples)

Jun 20, 2022 Excel Basics

We work in Excel for different purposes. Like, we work with currency-related operations, and there appear currency signs. And you could imagine a lot ...

How to Type Delta Symbol in Excel (8 Effective Ways)

Jun 23, 2022 Excel Basics

We store various information in our Excel worksheet. They include texts, numbers, and even symbols. But, the input symbols are not a straightforward ...

How to Insert Symbol in Excel (6 Simple Techniques)

Jun 14, 2022 Excel Basics

At times, we need to use symbols in our Excel file. In this article, I will show you the 6 quick and simple ways to insert a symbol in Excel. ...

How to Type Diameter Symbol in Excel (4 Quick Methods)

Jun 13, 2022 Excel Basics

In this article, we will learn to type the diameter symbol in Excel. The diameter symbol looks like an O with a slash. It is also known as ‘slashed ...

How to Insert Dot between Numbers in Excel (3 Ways)

Jun 2, 2022 Excel Basics

Sometimes, users need to insert a Dot between numbers or characters in Excel to display different parts of numbers or IDs. It’s common to insert dot ...

How to Replace Text with Carriage Return in Excel (4 Smooth Approaches)

Jun 1, 2022 Excel Formulas

For the fabrication of information, We can use Carriage Return. It means to return the beginning of the next line in the same cell. Here, We are ...

How to Replace a Character with a Line Break in Excel (3 Easy Methods)

Jun 2, 2022 Excel Formulas

In this article, I am going to explain how you can replace a character with a line break in excel. While working with data sometimes we might need to ...