Excelä¸replaceå½æ°ç使ç¨
ç¨ä¸å¥è¯æ¦æ¬replaceå½æ°ï¼æ¿æ¢æå®ä½ç½®åæ°éçæ§å符ï¼æ¯å¸¸è§çexcelå符å½æ°ä¹ä¸ï¼åºç¨è¾å¹¿ï¼å®ç¨æ§å¾å¼ºã
Excelæä¾çå½æ°åæ°ä¸ºï¼
=Replace(old_text,start_num,num_charsï¼new_text)
=Replaceï¼åå符串ï¼å¼å§ä½ç½®ï¼æ¿æ¢ä¸ªæ°ï¼æ¿æ¢æå符ï¼
举个ä¾åï¼
为ä¿æ¤éç§ï¼è¯·å°çµè¯å·ç 18502918888æå4为è¿è¡æ¨¡ç³åå¤çï¼æ¿æ¢ä¸º****ã
=Replaceï¼åå符串ï¼å¼å§ä½ç½®ï¼æ¿æ¢ä¸ªæ°ï¼æ¿æ¢æå符ï¼
=Replaceï¼A1ï¼8ï¼4ï¼â****âï¼
温馨提示:答案为网友推荐,仅供参考