| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do convert an entire column of text in Excel to all caps?
I'm trying to convert data (a list of names) in a single column to all caps.
I've tried copying and pasting the text from Word, but the data doesn't change. I can't get the instructions in Excel help to fix it either.... ARG!!!! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do convert an entire column of text in Excel to all caps?
In a column next to your data, enter the formula
=UPPER(A1) where A1 is the first cell of your data, and then copy down as far as you need to go. Then copy this result column and paste special values over your original data. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Carrie" wrote in message ... I'm trying to convert data (a list of names) in a single column to all caps. I've tried copying and pasting the text from Word, but the data doesn't change. I can't get the instructions in Excel help to fix it either.... ARG!!!! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do convert an entire column of text in Excel to all caps?
Assume first name is in A1
In B1 (if B is in use, then insert a new B column) enter =UPPER(A1) Copy formula down to last name (say row 100) Select B1:B100, click Copy tool; use Edit | Paste Special and check the Values box Now the data is not a formula So now you can delete column A best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Carrie" wrote in message ... I'm trying to convert data (a list of names) in a single column to all caps. I've tried copying and pasting the text from Word, but the data doesn't change. I can't get the instructions in Excel help to fix it either.... ARG!!!! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do convert an entire column of text in Excel to all caps?
In a helper column put this and copy down........then copy PasteSpecial
Values to delete the formulas....... =UPPER(A1) Vaya con Dios, Chuck, CABGx3 "Carrie" wrote: I'm trying to convert data (a list of names) in a single column to all caps. I've tried copying and pasting the text from Word, but the data doesn't change. I can't get the instructions in Excel help to fix it either.... ARG!!!! |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do convert an entire column of text in Excel to all caps?
Say you names are in column A. In an un-used column enter =UPPER(A1) and
copy down. Then copy the new column and paste/special as value back into A -- Gary's Student "Carrie" wrote: I'm trying to convert data (a list of names) in a single column to all caps. I've tried copying and pasting the text from Word, but the data doesn't change. I can't get the instructions in Excel help to fix it either.... ARG!!!! |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do convert an entire column of text in Excel to all caps?
This is also a standard feature of ASAP Utilities, available free at
www.asap-utilities.com Vaya con Dios, Chuck, CABGx3 "Carrie" wrote: I'm trying to convert data (a list of names) in a single column to all caps. I've tried copying and pasting the text from Word, but the data doesn't change. I can't get the instructions in Excel help to fix it either.... ARG!!!! |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do convert an entire column of text in Excel to all caps?
I must be a complete idiot, because I still couldn't get it to work.
Bummer. "Chip Pearson" wrote: In a column next to your data, enter the formula =UPPER(A1) where A1 is the first cell of your data, and then copy down as far as you need to go. Then copy this result column and paste special values over your original data. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Carrie" wrote in message ... I'm trying to convert data (a list of names) in a single column to all caps. I've tried copying and pasting the text from Word, but the data doesn't change. I can't get the instructions in Excel help to fix it either.... ARG!!!! |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do convert an entire column of text in Excel to all caps?
Where is your data?
In Chip's sample formula, he expected it to start in A1. If your data is in column G, then you can insert a new column H and put: =upper(g1) and drag that formula down the column. Carrie wrote: I must be a complete idiot, because I still couldn't get it to work. Bummer. "Chip Pearson" wrote: In a column next to your data, enter the formula =UPPER(A1) where A1 is the first cell of your data, and then copy down as far as you need to go. Then copy this result column and paste special values over your original data. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Carrie" wrote in message ... I'm trying to convert data (a list of names) in a single column to all caps. I've tried copying and pasting the text from Word, but the data doesn't change. I can't get the instructions in Excel help to fix it either.... ARG!!!! -- Dave Peterson |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do convert an entire column of text in Excel to all caps?
When I do this, my names are deleted/gone.
Anyone want to do this for me? "Gary''s Student" wrote: Say you names are in column A. In an un-used column enter =UPPER(A1) and copy down. Then copy the new column and paste/special as value back into A -- Gary's Student "Carrie" wrote: I'm trying to convert data (a list of names) in a single column to all caps. I've tried copying and pasting the text from Word, but the data doesn't change. I can't get the instructions in Excel help to fix it either.... ARG!!!! |
|
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do convert an entire column of text in Excel to all caps?
I'm on a government computer...I can't download anything to this computer.
Sorry. "CLR" wrote: This is also a standard feature of ASAP Utilities, available free at www.asap-utilities.com Vaya con Dios, Chuck, CABGx3 "Carrie" wrote: I'm trying to convert data (a list of names) in a single column to all caps. I've tried copying and pasting the text from Word, but the data doesn't change. I can't get the instructions in Excel help to fix it either.... ARG!!!! |
|
#11
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do convert an entire column of text in Excel to all caps?
Assuming that your existing name is in column A, use the following
function: =UPPER(A1) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Stop excel from dropping the 0 in the beginning of a number? | Setting up and Configuration of Excel | |||
| Date format not correct when you convert a CSV text file in Excel | Excel Discussion (Misc queries) | |||
| convert column data into text | Excel Discussion (Misc queries) | |||
| How can I make Excel return the text in column A only if there is. | Excel Worksheet Functions | |||
| convert a column of text to proper | New Users to Excel | |||
Linear Mode
