Disclosure: This post may contain affiliate links, meaning when you click the links and make a purchase, we receive a commission.

CHAR Function

How to Go to Next Line in Excel Cell (4 Simple Methods)

In most applications, you can easily go to the next line by just pressing Enter. But in Excel, this process is a little different. You can use the ...

How to Enter within a Cell in Excel (5 Methods)

If you want to Enter within a Cell in Excel, this article is for you. Here, we describe 5 methods to enter within a cell in Excel. Download Workbook ...

How to Add New Line with CONCATENATE Formula in Excel (5 Ways)

If you are looking for ways to add a new line in Excel using CONCATENATE formula, then you will find this article useful. So, let’s get started with ...

How to Replace Line Break with Comma in Excel (3 ways)

When we copy some text from somewhere to our Excel spreadsheet, sometimes some line break is trapped in those data. Removing this line break is quite ...

How to Make Alphabetical List in Excel (3 Ways)

To make your dataset cool and presentable Sorting alphabetically is one of the most used functions in Excel. Throughout this article, we will learn ...

How to Combine Duplicate Rows in Excel without Losing Data (6 Methods)

We’re going to show you 6 methods of how to combine duplicate rows in Excel without losing data. To demonstrate our methods, we’ve taken a dataset ...

How to Space Down in Excel (3 Methods)

In most office applications adding a new line, paragraph or space down is not a problem. But Microsoft Excel is different in this case. We will see ...

How to Remove Symbol in Excel (8 Ways)

There could be so many unwanted symbols and characters existing in excel cells, maybe from a typing mistake, or a symbol that was needed initially ...

How to Display Power in Excel (6 ways)

In Excel, we can easily calculate the value of different power/exponent of different base values. But they are often not shown in the traditional ...

How to Change Excel Column Name from Number to Alphabet (2 Ways)

The column names in Excel remain in alphabetical order by default. But it can be set to numerical order too. So if you somehow get that the column ...

Excel Find Last Occurrence of Character in String (6 Methods)

In this article, we’re going to find the last occurrence of a character in a string in Excel. Our sample dataset has three columns: Company Name, ...

How to AutoFill Sequential Letters in Excel (5 Quick Ways)

It will be very supportive if we can AutoFill sequential letters in Excel instead of putting them one at a time. In this article, I will try to show ...

Carriage Return in Excel Formula to Concatenate (6 Examples)

Often, we insert Carriage Return in Excel formula concatenate to make our data more comprehensible. We can insert a Carriage Return in formula ...

How to Concatenate Multiple Cells With Space in Excel (7 Methods)

When dealing with Microsoft Excel, we occasionally need to concatenate multiple cells with their values using Excel formulas. We can easily ...

How to Concatenate Two Columns in Excel with Hyphen (9 Quick Ways)

If you are looking for some of the easiest ways to concatenate two columns in Excel with hyphen, then you will find this article useful. So, let’s ...

ExcelDemy
Logo