How to add text or character in excel formula

August 1, 2022
1.2K Views
0

A free Office suite fully compatible with Microsoft Office

Free Download

A free Office suite fully compatible with Microsoft Office

Free Download

For formulating, storing and finalizing the data in excel, formulas are used. Formulas are the most essential part of organizing and analyzing data in excel. Formulas make help the excel users in accessing and activating many excel features. Formula is a quick function which saves time and allow the excel users to create an accurate worksheet. For analyzing and storing limited amount of data, formulas might not be needed but for organizing a large amount of data formulas are of great importance. These formulas work with2016\2019\mac\online versions.

Excel consists of a formula box where the users can input any type of formula to formulate their data. This feature also enables the users to avail other functions of excel that help them in organizing and analyzing data. Formulas consist of several text or characters. For the activation of certain feature in excel, the characters and text used in a formula must be accurate. In this article we will discuss some examples that will help the readers in adding text or character in their formulas. These methods are applicable for 2016\2019\mac\online versions.

How To Add Text Or Characters In Excel Formula?

Many excel users use shortcuts in formula to save their time in organizing data. But for some users it becomes difficult to comprehend data containing formulas devoid of text. For this purpose adding text in formulas may help the users to easily comprehend the data. Suppose we need to find the total marks of a student in excel worksheet. To create data in more accurate form we can add text or character in formula by following given steps which work with 2016\2019\mac\online versions.

1. First we will select cell A2 consisting of the name of student in the formula box.

2. Then we will add the phrase “total marks are”. After that we will use the ampersand operator.

3. Then we do calculations by add in cell B2 and C2 to get the total marks of the student.

4. The result will be production of a more elaborated data.

This process is applicable for 2016\2019\mac\online versions.

How To Add Text Or Characters In Excel Formula In Time Format?
For calculation of time format we can add text in formula box to produce a more explained detail. For example in a data the arrival and departure time of a train is mentioned. To add text or characters in formula we will follow the steps given below which are compatible for 2016\2019\mac\online versions.

1. First we will select cell A2 containing the train number.

2. Then we will add phrase “total time duration” is and we will add the ampersand operator.

3. After that we will add C2-B2 which is the total time duration to produce an accurate data.

This procedure works with 2016\2019\mac\online versions.

Important Points For Adding Text Or characters in excel formula

There are some important points we have to keep in mind before entering text in excel formula

1. For the separation of two different texts in the same cell we should use ampersand operator or CONCATENATE Function.

2. We use proper text function and accurate format to get the correct data.

3. All the methods discussed above are applicable for 2016\2019\mac\online versions.

Did you learn about how to add text or character in excel formula using different methods? You can follow WPS Academy to learn more features of Word Document, Excel Spreadsheets, and PowerPoint Slides.

You can also download WPS Office to edit the word documents, excel, and PowerPoint for free of cost. Download now! And get an easy and enjoyable working experience.