ExcelBanter - problem in ms excel

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - problem in ms excel (https://www.excelbanter.com/excel-discussion-misc-queries/160463-problem-ms-excel.html)

Wei

problem in ms excel

how to do if small letter change to capital letter?

Max

problem in ms excel

In B1: =UPPER(A1)
will change lower case text in A1 to upper case

Copy B1 down as needed.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"wei" wrote:
how to do if small letter change to capital letter?

All times are GMT +1. The time now is 10:40 AM.