e.g.1 : hong kong island --> Hong Kong Island
e.g.2: HONG KONG ISLAND --> Hong Kong Island
更新1:
e.g.3: HONG kong island --> Hong Kong Island
EXCEL公式問題
2010-06-25 10:27 am
點先可以將一串生字由全部細楷/大楷變成第一個字母係大楷, 其餘係細楷??
e.g.1 : hong kong island --> Hong Kong Island
e.g.2: HONG KONG ISLAND --> Hong Kong Island
e.g.1 : hong kong island --> Hong Kong Island
e.g.2: HONG KONG ISLAND --> Hong Kong Island
回答 (1)
2010-06-25 3:28 pm
✔ 最佳答案
設資料在 A1B1 = PROPER(A1)
請試試
收錄日期: 2021-04-24 10:28:54
原文連結 [永久失效]:
https://hk.answers.yahoo.com/question/index?qid=20100625000051KK00168