now that i have formatted the text to "proper" ...

  • Thread starter Thread starter catjea2000
  • Start date Start date
C

catjea2000

is there a way to remove the cells that are still in all caps without losing
the "proper" column?
 
Hi,

2 ways.

1. Hide the column with the capitalised words in.

or

2. Copy the 'Proper' colmn and paste it back over itself using
Edit|Paste special
paste values
then delete the capitalised column

Mike
 
Yes.

Copy the the column with the PROPER formulas.

Edit>Paste Special(in place)>Values>OK>Esc.

Now delete the original column.


Gord Dibben MS Excel MVP
 

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

Insert "Proper Function" into existing macro 10
Init Caps 2
AutoFit not working properly 2
Formating - Date as Month In All Caps 5
How do I apply the formula =PROPER(text) to existing text in works 1
How can I use one formula to change case on an entire worksheet? 2
Merge cells time format 4
Is there a way to change Lowercase or Proper to ALL CAPS? 2

Back
Top