how do i change the case text in a column?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I followed the directions as listed under CLR's post, however I am unable to
figure out how to copy down the column as well.
 
Would have been nice if you had stuck to the original thread but in the absence
of any detail...................

Enter =casefunction(A1) in B1

Double-click on the fill handle of B1 to copy down.

casefunction would be LOWER, UPPER or PROPER depending upon your needs.


Gord Dibben MS Excel MVP
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do add another code to a current one? 4
Image not displaying in datagridview column in vb.net 1
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Invalid Column Name Sql-Error :Executing a stored procedure 1
Last Modified By in a cell by user 3
Formula 0
How do I wrap text in the subject column in the list of tasks 2

Back
Top