Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
In a column, how can I capitalize ALL text?
I am highlighting a column. I assume there must be a way to capitalize ALL
text in the column without actually doing it manually.....Please reply like I am a 5 year old and tell EXACTLY where to go from the beginning to the end....I am very new at this and have been at it for hours...again please be very basic with me....I THANK YOU! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
In a column, how can I capitalize ALL text?
Hi,
Say you want to capitalise Column A. Put this in B1 and drag down:- =Upper(A1) Mike "singmusik04" wrote: I am highlighting a column. I assume there must be a way to capitalize ALL text in the column without actually doing it manually.....Please reply like I am a 5 year old and tell EXACTLY where to go from the beginning to the end....I am very new at this and have been at it for hours...again please be very basic with me....I THANK YOU! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
In a column, how can I capitalize ALL text?
Assuming the column of data you want to change is in Column Astarting from
A1: 1 Insert a new Column B clicking into the 'B' of the column and selecting: Insert Columns 2 Enter in B2 then formula: =UPPER(A1) this will put the contents of A1 in B1 in upper case 3 Select cell B1 and hover the cursor over the bottom right-hand corner of cell B1, (where there is a small black square). When it changes from a big white cross into black cross-hairs double left-click and the foruma will be copied down Column B as far as the data goes in Column A. 4 With the new data still selected, right-click and select copy then select cell A1 and right-click and select Paste Special Values. This will enter the upper case data into Column A 5 Finally select and delete the helper Column B -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "singmusik04" wrote in message ... I am highlighting a column. I assume there must be a way to capitalize ALL text in the column without actually doing it manually.....Please reply like I am a 5 year old and tell EXACTLY where to go from the beginning to the end....I am very new at this and have been at it for hours...again please be very basic with me....I THANK YOU! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
In a column, how can I capitalize ALL text?
I thank you for your response very much.....however, I am not sure exactly
what you mean by "drag down"....the first cell is the only one that is capitalize....how do i get the hundreds of others to captalize too? THANK YOU VERY MUCH!! "Mike H" wrote: Hi, Say you want to capitalise Column A. Put this in B1 and drag down:- =Upper(A1) Mike "singmusik04" wrote: I am highlighting a column. I assume there must be a way to capitalize ALL text in the column without actually doing it manually.....Please reply like I am a 5 year old and tell EXACTLY where to go from the beginning to the end....I am very new at this and have been at it for hours...again please be very basic with me....I THANK YOU! |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
In a column, how can I capitalize ALL text?
THANK YOU BOTH OF YOU....YOU ARE GENIUSES!!!!
"Sandy Mann" wrote: Assuming the column of data you want to change is in Column Astarting from A1: 1 Insert a new Column B clicking into the 'B' of the column and selecting: Insert Columns 2 Enter in B2 then formula: =UPPER(A1) this will put the contents of A1 in B1 in upper case 3 Select cell B1 and hover the cursor over the bottom right-hand corner of cell B1, (where there is a small black square). When it changes from a big white cross into black cross-hairs double left-click and the foruma will be copied down Column B as far as the data goes in Column A. 4 With the new data still selected, right-click and select copy then select cell A1 and right-click and select Paste Special Values. This will enter the upper case data into Column A 5 Finally select and delete the helper Column B -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "singmusik04" wrote in message ... I am highlighting a column. I assume there must be a way to capitalize ALL text in the column without actually doing it manually.....Please reply like I am a 5 year old and tell EXACTLY where to go from the beginning to the end....I am very new at this and have been at it for hours...again please be very basic with me....I THANK YOU! |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
In a column, how can I capitalize ALL text?
In row 1 of a blank column, in the first cell type the formula =UPPER(A1)
[replacing A by the column letter of the column you are tyring to process]. Accept that formula, select that cell, then hover your mouse over the the bottom right-hand corner of that cell so that the cursor changes to a + sign, click and drag that down your blank column for as many rows as you've got entries in the column you are trying to process. Your new column should now be the equivalent in capitals of your original column. If you want to replace the original by the capitalised version, select the column with the capitalised version, copy, then select the original column, Edit/ Paste Special/ Values, and OK. This should paste your new values over the old ones, so you can now delete the column where you calculated the capitalised version. -- David Biddulph "singmusik04" wrote in message ... I am highlighting a column. I assume there must be a way to capitalize ALL text in the column without actually doing it manually.....Please reply like I am a 5 year old and tell EXACTLY where to go from the beginning to the end....I am very new at this and have been at it for hours...again please be very basic with me....I THANK YOU! |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
In a column, how can I capitalize ALL text?
Drag down means to select the fill handle of B1 with left click and drag.
The formulas will copy and increment as you drag/copy down column B. Easier method would be to double-click on the fill handle of B1 to copy down to end of data in column A. The fill handle is the little black cross that appears when you hover the cursor over the black square at bottom right of the cell.........B1 in this case. Gord Dibben MS Excel MVP On Mon, 10 Sep 2007 04:12:01 -0700, singmusik04 wrote: I thank you for your response very much.....however, I am not sure exactly what you mean by "drag down"....the first cell is the only one that is capitalize....how do i get the hundreds of others to captalize too? THANK YOU VERY MUCH!! "Mike H" wrote: Hi, Say you want to capitalise Column A. Put this in B1 and drag down:- =Upper(A1) Mike "singmusik04" wrote: I am highlighting a column. I assume there must be a way to capitalize ALL text in the column without actually doing it manually.....Please reply like I am a 5 year old and tell EXACTLY where to go from the beginning to the end....I am very new at this and have been at it for hours...again please be very basic with me....I THANK YOU! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I Capitalize all the font on a worksheet? | Excel Discussion (Misc queries) | |||
Number Format - Capitalize | Excel Discussion (Misc queries) | |||
Capitalize Text if 2 lists are equal | New Users to Excel | |||
How do I capitalize and parse in the same formula? | Excel Worksheet Functions | |||
Capitalize text | Excel Discussion (Misc queries) |