Microsoft Excel : edit data

If you have to forces the alphabet change to be upper case when entering, you have to use Excel VBA code to do so.

Otherwise you can convert the text to upper case by using Excel function UPPER in other column.

Let your Data in cells A1 is “abc”, then in cells B1 you can input
=UPPER (A1)
the answer will then turn to be “ABC”.

設資料已輸入在A行
highlight 整行A
編輯 --- 取代 --- 尋找 (e.g. a) --- 取代成 (e.g. A)