Home >Topics >excel >How to use excel right function

How to use excel right function

藏色散人
藏色散人Original
2021-05-08 11:00:4619458browse

The function of excel right function is to filter out the last one or more characters of the specified string. Its usage syntax is "RIGHT(text,[num_chars])".

How to use excel right function

The operating environment of this article: Windows 7 system, Microsoft Office Excel 2010 version, DELL G3 computer

RIGHT function function

Filter Get the last one or more characters of the specified string;

The syntax structure of the RIGHT function

RIGHT(text,[num_chars])

How to use the RIGHT function

Take the following table as an example to demonstrate this function How to use;

How to use excel right function

1. Call the RIGHT function and enter =right in the specified cell;

How to use excel right function

2. Set the text string to be filtered;

How to use excel right function

3. Set the number of characters to enter;

How to use excel right function

4. Click Press Enter to view the function result;

How to use excel right function

5. Place the mouse on the lower right corner of the cell where the result was just output. When the mouse icon changes to " ", drag it down. , complete the form filling.

How to use excel right function

Recommended study: "Excel Tutorial"

The above is the detailed content of How to use excel right function. For more information, please follow other related articles on the PHP Chinese website!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn