Changing single column default to Upper case
 

Can I set the default for a single column in Excel 2000 to Upper case. I keep
a lot of address information in various spreadsheets and would like to
default the Post Town column to Upper case, ready to mail merge.
Thankyou
Graham

Hi graham,

Pls try this in cell B1
=upper(A1)


"Graham" wrote:

Can I set the default for a single column in Excel 2000 to Upper case. I keep
a lot of address information in various spreadsheets and would like to
default the Post Town column to Upper case, ready to mail merge.
Thankyou
Graham

Many Thanks Anirudh - I have been using this as a "work around", but this
requires two columns, and I would like to have the text converted in a single
column, either when I type it in, or when it is pasted in from another sheet.
I collate info from many similar sheets, and want to try and get some
consistancy in appearance.

"Anirudh" wrote:

Hi graham,

Pls try this in cell B1
=upper(A1)


"Graham" wrote:

Can I set the default for a single column in Excel 2000 to Upper case. I keep
a lot of address information in various spreadsheets and would like to
default the Post Town column to Upper case, ready to mail merge.
Thankyou
Graham

Take a look at Chip Pearson's page:
http://cpearson.com/excel/case.htm

Graham wrote:

Many Thanks Anirudh - I have been using this as a "work around", but this
requires two columns, and I would like to have the text converted in a single
column, either when I type it in, or when it is pasted in from another sheet.
I collate info from many similar sheets, and want to try and get some
consistancy in appearance.

"Anirudh" wrote:

Hi graham,

Pls try this in cell B1
=upper(A1)


"Graham" wrote:

Can I set the default for a single column in Excel 2000 to Upper case. I keep
a lot of address information in various spreadsheets and would like to
default the Post Town column to Upper case, ready to mail merge.
Thankyou
Graham

--

Dave Peterson

If you want to change to Upper Case as you enter data in the Post Town column
you could use a worksheet event.

Private Sub Worksheet_Change(ByVal Target As Excel.Range)
If Target.Column < 1 Then Exit Sub
On Error GoTo ErrHandler
Application.EnableEvents = False
Target.Formula = UCase(Target.Formula)
ErrHandler:
Application.EnableEvents = True
End Sub

Target.Column number to be your Post Town column.

Right-click on the sheet tab and "View Code"

Paste the above into that module.


Gord Dibben Excel MVP

On Tue, 27 Sep 2005 07:28:40 -0500, Dave Peterson
wrote:

Take a look at Chip Pearson's page:
http://cpearson.com/excel/case.htm

Graham wrote:

Many Thanks Anirudh - I have been using this as a "work around", but this
requires two columns, and I would like to have the text converted in a single
column, either when I type it in, or when it is pasted in from another sheet.
I collate info from many similar sheets, and want to try and get some
consistancy in appearance.

"Anirudh" wrote:

Hi graham,

Pls try this in cell B1
=upper(A1)


"Graham" wrote:

Can I set the default for a single column in Excel 2000 to Upper case. I keep
a lot of address information in various spreadsheets and would like to
default the Post Town column to Upper case, ready to mail merge.
Thankyou
Graham