Someone sent me a very large spreadsheet entirely in uppercase. Extremely hard to read. is there an easy way to change a range of cells from uppercase to proper case. Using Excel 2007

--

Regards
Michael Koerner

If you really mean Proper then
=PROPER(A1)
will do it but that capitalises the first letter of every word which is an
improvement on all caps but not ideal.
Fir a solution try here
http://www.mvps.org/dmcritchie/excel/proper.htm#proper

Mike
"Michael Koerner" wrote:

> Someone sent me a very large spreadsheet entirely in uppercase. Extremely hard to read. is there an easy way to change a range of cells from uppercase to proper case. Using Excel 2007
>
> --
>
> Regards
> Michael Koerner
>
>

Hi MK,

Change the range to suit:

Sub UpperToProper()
Dim Cell As Object
For Each Cell In Range("A1:E3")
Cell = Application.WorksheetFunction.Proper(Cell)
Next
End Sub

Cheers,
JF

Only use this if you don't mind losing all your formula

"(E-Mail Removed)" wrote:

> Hi MK,
>
> Change the range to suit:
>
> Sub UpperToProper()
> Dim Cell As Object
> For Each Cell In Range("A1:E3")
> Cell = Application.WorksheetFunction.Proper(Cell)
> Next
> End Sub
>
> Cheers,
> JF
>

You could try this, too .. not confident it works for 2007, it uses
VBA convertion instead of Excel's ...:

(After you've selected a bunch of cells)

dim strCellText as string
For Each Cell In Selection
strCellText = Cell
strCellText = StrConv(strCellText, vbProperCase)
Next Cell

Chris

On Mar 6, 8:22*am, joshuafanda...@dsl.pipex.com wrote:
> Hi MK,
>
> Change the range to suit:
>
> Sub UpperToProper()
> Dim Cell As Object
> * For Each Cell In Range("A1:E3")
> * Cell = Application.WorksheetFunction.Proper(Cell)
> * Next
> End Sub
>
> Cheers,
> JF

Thanks very much, will give it a shot.

--

Regards
Michael Koerner


"Mike H" <(E-Mail Removed)> wrote in message news:1A646A2F-D1FB-4DFB-B02A-(E-Mail Removed)...
If you really mean Proper then
=PROPER(A1)
will do it but that capitalises the first letter of every word which is an
improvement on all caps but not ideal.
Fir a solution try here
http://www.mvps.org/dmcritchie/excel/proper.htm#proper

Mike
"Michael Koerner" wrote:

> Someone sent me a very large spreadsheet entirely in uppercase. Extremely hard to read. is there an easy way to change a range of cells from uppercase to proper case. Using Excel 2007
>
> --
>
> Regards
> Michael Koerner
>
>