Although perhaps few people may know, it is possible to use functions to facilitate the manipulation of texts in Excel. That's why in this Saturday's MenosFios Office we're going to show you how to use 5 types of these functions, so that you can change the information in a spreadsheet in a practical way.
CONCATENATE
This feature is for you to group text items. As you can see in the photo above, in cell C11 there is the value 10.095,90.
So that you can unite the text "Total“, which will be typed, with the value that is already in the table, we need to use the Concatenate function. So, as it is a formula, you must first type the equals character and then type CONCATENATE, then open and close parentheses and insert the text between quotes.
If you want a white space, you will have to insert quotation marks between them, and not forgetting that each argument needs to be separated with a semicolon, as shown in the figure below.
Then Excel will display the result below.
UPPERCASE
This functionality in Excel converts all letters in the text to uppercase. As you can see in the photo below, in cell B3 there is the text “Good morning“, and when typing the following function: =UPPERCASE(B3), Excel will offer the following result:
LOWER
This functionality in Excel converts all letters in the text to lowercase. As you can see in the photo below, in cell B3 there is the text “GOOD MORNING“, and when typing the following function: =LOWER (B3), Excel will offer the following result:
ADDED VALUE OF
This functionality turns a text argument into a number. As you can see in the photo below, in cell B3 there is the text “1500“, and when typing the following function: =VALUE(“1500”), Excel will offer the following result:
REPLACE
With this function you will replace one text with another in the same cell, where in order to use it you will have to access the arguments panel of the function or type it manually.
As shown in the photo below, in cell B3, the text was first typed: “First two months".
To replace, just click on the “Insert Function” tool.
Then the function arguments panel will open.
In the field "Text“, you must provide a text, which will be replaced or in parts by a new value. To the field "old_text“, you must enter the same text as the previous field, or else a part of it that you want to replace. Finally, in "new_text“, you must inform the text that will replace the old one.
Then, Excel will display the following result.
