How to keep only the integer part of data in excel
- 王林Original
- 2020-05-29 09:23:4710323browse
Open the "Excel" software and select the data to be replaced.
Press the "Ctrl H" shortcut key to open the replacement window.
In the Find what box, enter ".*" and click "Replace All".
Recommended tutorial: excel tutorial
The above is the detailed content of How to keep only the integer part of data in excel. 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
Previous article：What is the data type of date data in excel 2010?Next article：What is the data type of date data in excel 2010?