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
They are the same thing, excel is Microsoft's spreadsheet programme.
Add a sheet
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.