Change Capitalization Format in Excel

[lmarshall]

I am working on a mailing list for a charity's fundrasier event. I received an Excel file from a person, but the names and addresses are in CAPS. Is there a way to format this file so that the only thing that is in CSPS is the first letter in each of the fields instead of the entire document?

Thanks!

 

[Loomah]

Hi
Have look at the Proper function. I's a worksheet function but it would involve creating another sheet with the formula looking at your original and then copying & pasting values.

If you're comfortable with VBA you could select all the cells you want to change and run the following code

Sub A()
Dim c As Range
For Each c In Selection
c = WorksheetFunction.Proper(c)
Next
End Sub

;-)

If a man says something and there are no women there to hear him, is he still wrong?
How do I get the best answers?​

 

[lmarshall]

Thanks! I got it in another sheet but is there away in Excel to "finalize" the look? I would like to copy this data over to an another excel sheet that already contains our mailing list. Is there a way to do this as well?

 

[Loomah]

Yeah! You need to copy your formulas and
EDIT>PASTE SPECIAL>VALUES
either back to the same cells from where they were copied or to a new location.

;-)

If a man says something and there are no women there to hear him, is he still wrong?
How do I get the best answers?​

 

[lmarshall]

Awesome! Thanks for your help!

 

[arthurbr]

Loomah, may I suggest another approach?
Instead of Edit paste, etc.. select the region with the formulas
Right click the upper border of the selection
Drag and drop the selection while holding the right button in ( you can drop it at the same placeif you like).
A nice menu will appear
Select " Copy here as values only"
And that's it, formulas are replaced by values
(that is of course a one shot operation)
Greetings

André

 

[Loomah]

Andre
The more suggestions the merrier, I say!!

I tend to forget about the drag/drop options with the right mouse button. Only real problem is the method falls down if you do actually ned to copy to another worksheet!!

;-)

If a man says something and there are no women there to hear him, is he still wrong?
How do I get the best answers?​

 

[arthurbr]

Loomah,
thanks for your appreciation
I'm not very good at XL, but the guys and girls who developed it, did a good job. I'm learning everyday.
IF Access had more XL , and XL more access, life would be much easier

 

[firefytr]

Also take a look at the addin from

http://www.asap-utilities.com

HTH

-----------
Regards,
Zack Barresse