Thursday, 27 September 2012

Change case of text in Excel 2003 and Excel 2007

There'are many situation when we want change case of text in excel after data entry.
There may a huge amount of text within a column which you want to  change.
you can use excel function upper,lower and proper how? Take a look..

Change Text Case in excel 2007




  • Enter your text As in image
  • select column near of your text cell as in image
  •  If There is not  space for a column then right click select insert and add entire column
  • Enter Formula as you want apply
      e.g. =upper(b1) 
      drag it down side
  • Now Select change text and copy it
  • Click on cell where actual change has to be done
  • Highlight Home from ribbon control select paste and pick paste values
  • Now you can delete column which had add...