| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Chg existing cells fr Proper to Upper w/o re-typing.
I have several workbooks that have several worksheets that need a particular
group of cells to be in Upper Case. These cells are currently occupied with proper case words. Can I change them to Upper case without having to retype all the information in these cells? If so, how? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Chg existing cells fr Proper to Upper w/o re-typing.
in a parallel range, enter =UPPER(A1) (or wherever the data is) & fill down'
Copy the result, paste/special values onto the original; remove the formulas. Bob Umlas Excel MVP "stacylynnbug" wrote in message ... I have several workbooks that have several worksheets that need a particular group of cells to be in Upper Case. These cells are currently occupied with proper case words. Can I change them to Upper case without having to retype all the information in these cells? If so, how? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Chg existing cells fr Proper to Upper w/o re-typing.
You can use the UPPER function. =UPPER(A1) where your text is in A1. Copy down as needed. HTH Steve -- SteveG ------------------------------------------------------------------------ SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571 View this thread: http://www.excelforum.com/showthread...hreadid=515958 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I change text to proper text in multiple cells. | Excel Discussion (Misc queries) | |||
| How to input additional text to multiple of existing cells that has text | Excel Worksheet Functions | |||
| getting data from cells in wrksheet & importing in existing works | Excel Discussion (Misc queries) | |||
| How to add another line in cells with existing text? | New Users to Excel | |||
| How do I change existing text from lower case to upper case | Excel Discussion (Misc queries) | |||
Linear Mode
