請問在excel如何將一排英文字由small letter轉capital letter?

Say A1 is what you want to change, then the formula is

Upper(A1)

Further question, send me e-mail.

change in word, then copy and paste la

唔得，你要重新打過先得。