PDA

View Full Version : excel



25-07-2001, 05:33 PM
I am transcribing text lists to excel and wonder if there is a way to make the program default the first letter as upper case at the beginning of each cell?

26-07-2001, 10:29 AM
There is no worksheet formatting available which will do this.
Using Visual Basic to capture the Worksheet_Change event, a macro can be supplied which will convert text entries to Lower, Upper or Proper case (every word starting with upper case letters). Having only the first letter of the first word in a sentence as upper case is not supported.