UPPER CASE

  • Thread starter Thread starter JURBOP
  • Start date Start date
J

JURBOP

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.
 
.. 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
---
 
Back
Top