Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changing file in all upper case to upper and lower case | Excel Discussion (Misc queries) | |||
convert value in word. For Exampe Rs.115.00 convert into word as . | Excel Discussion (Misc queries) | |||
Amount or Numbers in Words | New Users to Excel | |||
Convert Numeric into Text | Excel Worksheet Functions | |||
Identifying the Active Fill Color | Excel Discussion (Misc queries) |