You use the Upper function. So if the text is in A1, then in another cell put the formula:
=UPPER(A1)
The Lower function will change from upper case to lower case. The Proper function will give you a capital letter at the start and small letters for the rest.
=LOWER(A1)
=PROPER(A1)
lower("WHAt evEr") would return "what ever"
To export the Access database to an Excel sheet in an easy way and for a detailed explanation, see the related links.
how to create a excel sheet
Pfa the excel sheet
Add a sheet
They are the same thing, excel is Microsoft's spreadsheet programme.
1) Copy the data to be converted 2) Paste Specialand tick the Transpose box
Calculating DSCR in Excel sheet
Select the sheet.
A spread sheet
17,179,869,184 cells in one excel
I believe chart sheet.