Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
UPPER CASE
Hi;
I'm running EXCEL 2003 and Windows XP Professional. I have a spreadsheet with over 7,000 rows. I have a column that has text in it when there's data in a row. I need to convert all of the text in that column to upper case. I've checked the HELP files but could not find any information to solve this problem. Is there a way of putting together a formula or function using =UPPER, or some other method? Please respond as I am at a stand still. Thanks. Nick Jury. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
UPPER CASE
.. need to convert all of the text in that column to upper case
Assume that col is col A, with data in A2 down You could put in B2: =UPPER(A2) then just copy B2 down all the way to the last row of data in col A -- Max Singapore http://savefile.com/projects/236895 Downloads:19,500 Files:362 Subscribers:62 xdemechanik --- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
change data of entire column from small case to upper case | Excel Worksheet Functions | |||
Changing multiple cell text from lower case to upper case | Excel Discussion (Misc queries) | |||
Changing upper case characters to upper/lower | Excel Discussion (Misc queries) | |||
Changing file in all upper case to upper and lower case | Excel Discussion (Misc queries) | |||
How do I convert all upper case excel sheet into upper and lower . | Excel Discussion (Misc queries) |