Format text in Excel 2003?

[Kristie Cochran]

Is it possible to change the formatting of text in Excel? I have a
database list that I downloaded from the city tax records and all of the
names and addresses are in all caps. I'd like to change everything to
Title Case. I copy and pasted the info into Word and formatted it
there, but when I tried to paste it back into Excel, the old formatting
showed back up. Is there a way for me change the formatting in Excel?

TIA,
Kristie

 

[Bernard Liengme]

I just did an experiment: In two cells in Excel 2003 I entered MAIN STREET
and GRAND AVENUE. I copied these to Word and use Format | Change Case ->
Title to get Mina Street and Grand Avenue. When I copied and pasted these
back to Excel they stayed in Title (aka Proper) case. Wonder why yours
changes. In Excel, there is a difference between the displayed (formatted)
and the stored value but I do not think this is so in Word.


But if you cannot make it work, here is another way. Let's say you data base
is in A1200 of Sheet1. In A1 of Sheet2 enter =PROPER(Sheet1!A1) and copy
this formula across and down to fill A1200.

With the range still selected use Copy followed by Edit | Paste Special and
specify Values in the Paste Special dialog.

Now you have what you need and can delete Sheet1.

best wishes