想請教在excel中如 何將小寫英文轉換成大寫字母....
請教教我!
謝謝!
upper ("abc")===>ABC最初由 chyi
想請教在excel中如 何將小寫英文轉換成大寫字母....
請教教我!
謝謝!
lower ("ABC")===>abc
proper ("john smith")===>John Smith
看看書或許瞭解更多
沒這功能耶~ 那就寫個小巨集用用吧..
Sub 小寫轉大寫()
For Each c In ActiveSheet.UsedRange.Cells
c.Value = Ucase(c)
Next
End
<span style="filter:glow(color=3CB371,strength=4);width:100%;color:#3CB371;font-family:Comic Sans MS;font-size:18;font-weight:bold">No desire, No pain.</span><p><span style="filter:glow(color=FF4500,strength=3);width:100%;color:#FF8C00;font-family:Comic Sans MS;font-size:18;font-weight:bold">Before Asking, You should RTFH, RTFM, STFW...</span>
書籤