Thread: UPPER CASE
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Max Max is offline
external usenet poster
 
Posts: 9,221
Default 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
---