:"Comprehensive mastery of the REPLACE function: techniques for efficiently replacing old and new characters in text"-Table skills免费ppt模版下载-道格办公
投稿
  1. JustNewsHome
  2. Table skills
  3. "Comprehensive mastery of the REPLACE function: techniques for efficiently replacing old and new characters in text"

"Comprehensive mastery of the REPLACE function: techniques for efficiently replacing old and new characters in text"

Author: daogeziyuan • • Table skills • Views 653
Video source: [https://font2020.oss-cn-beijing.aliyuncs.com/wps/videos/1870432a738dd35f33ec0a45d7b5c7eb.mp4](https://font2020.oss-cn-beijing.aliyuncs.com/wps/videos/1870432a738dd35f33ec0a4 5d7b5c7eb .mp4) The REPLACE function can replace part of a text string with a different text string based on the specified number of characters. ### Syntax REPLACE(old_text, start_num, num_chars, new_text)- **old_text** is the text whose characters are to be replaced. - **start_num** is the position of the character in **old_text** to be replaced with **new_text**. - **num_chars** is the number of characters you want REPLACE to replace **old_text** with **new_text**. - **new_text** is the text that will replace the characters in **old_text**. ### Example 1. `=REPLACE(abcdefghijk,6,5,*)` The result is (abcde*k): replace five characters starting from the sixth character. 2. `=REPLACE(2009,3,2,10)` The result is 2010: Replace the last two digits of 2009 with 10. 3. `=REPLACE(123456,1,3,@)` The result is @456: Replace the first three characters with @. In the table, if you need to hide the numbers in the mobile phone number, you can use the REPLACE function to achieve this. For example, to hide the four digits in a mobile phone number, you can follow these steps: 1. Place the cursor in cell B2. 2. Click Formula - Insert Function - REPLACE Function in the upper menu bar. 3. Enter A2 in the original string, 4 in the starting position, 4 in the number of characters, and **** in the new string. 4. Click OK to hide the 4 digits in your phone number. Tutorial dividing line picture: [Tutorial dividing line.png](https://font2020.oss-cn-beijing.aliyuncs.com/wps/images/bccf8f501a092ee62d67745e209abab1.png) Explanation GIF picture: [1.gif](https:/ /font2020.oss-cn-beijing.aliyuncs.com/wps/images/137c772092bc6675a1186432c082bba9.gif)

Articles are uploaded by users and are for non-commercial browsing only. Posted by: Lomu, please indicate the source: https://www.daogebangong.com/en/articles/detail/quan-mian-zhang-wo-REPLACE-han-shu-gao-xiao-ti-huan-wen-ben-zhong-de-xin-jiu-zi-fu-ji-qiao.html

Like (810)
Reward 支付宝扫一扫 支付宝扫一扫
Lomu 阿阿阿菲 Columnist
48 196
single-end

Related Suggestion