在Excel中能否將大小楷之英文字轉變為全大楷的英文字嗎???

💻 軟件台其他 - 電腦

[匿名]

2007-09-22 5:52 am

Example:

I'm Chan Tai Man change to I'M CHAN TAI MAN in the Excel cell.

更新1:

Because i have a thousand of data need to change, how can i fix it and change faster??

更新2:

I copy and paste in the Marco, when i run the Marco, it shows Compile error: Syntax error. What's happened??

回答 (2)

joe

2007-09-22 10:37 pm

假設你的ｄａｔａ範圍　在　A1:Z100, 下列 MACRO 可完成任務:
Dim ran As Range
Sub macro()
Set ran = Range("a1:z100")
For Each c In ran
x = c.Text
y = UCase(x)
c.Value = y
Next

End Sub
-----------------------------------------------------------

你可改變data 範圍　to suit your need.

👍 0 👎 0

我是貓

2007-09-22 5:59 am

用 function =upper( cell number )

👍 0 👎 0

收錄日期: 2021-04-18 23:25:43
原文連結 [永久失效]:
https://hk.answers.yahoo.com/question/index?qid=20070921000051KK03897

檢視 Wayback Machine 備份