Caps formular please help
 

I have this "dog, cat, mice"

I want to achieve this Dog, Cat, Mice.

All help appreciated.

Thanks

Caps formular please help
 

A1: dog, cat, mice
A2: =PROPER(A1)
--
John C


"Yossy" wrote:

I have this "dog, cat, mice"

I want to achieve this Dog, Cat, Mice.

All help appreciated.

Thanks

Caps formular please help
 

If that is in A1, then put this formula in B1:

=PROPER(A1)

Select B1 again and <copy it, then Edit | Paste Special | Values
(check) | OK then <Enter. Then just <copy <paste it over the
original, and delete B1.

(Not quite as easy as Word !!)

Hope this helps.

Pete

On Jul 25, 8:58*pm, Yossy wrote:
I have this "dog, cat, mice"

I want to achieve this Dog, Cat, Mice.

All help appreciated.

Thanks

Caps formular please help
 

If you have a larger data set you might want to use a macro

Sub PropCase()
Application.DisplayAlerts = False
Dim R As Range
For Each R In Selection.Cells
If R.HasFormula Then
R.Formula = "=PROPER(" & Mid(R.Formula, 2) & ")"
Else
R.Value = Application.Proper(R.Value)
End If
Next
Application.DisplayAlerts = True
End Sub




http://www.mvps.org/dmcritchie/excel/install.htm

--


Regards,


Peo Sjoblom

"Yossy" wrote in message
...
I have this "dog, cat, mice"

I want to achieve this Dog, Cat, Mice.

All help appreciated.

Thanks

Caps formular please help
 

thanks to all. i appreciate it.

"Pete_UK" wrote:

If that is in A1, then put this formula in B1:

=PROPER(A1)

Select B1 again and <copy it, then Edit | Paste Special | Values
(check) | OK then <Enter. Then just <copy <paste it over the
original, and delete B1.

(Not quite as easy as Word !!)

Hope this helps.

Pete

On Jul 25, 8:58 pm, Yossy wrote:
I have this "dog, cat, mice"

I want to achieve this Dog, Cat, Mice.

All help appreciated.

Thanks

Caps formular please help
 

You're welcome - appreciate the feedback.

Pete

On Jul 25, 9:10*pm, Yossy wrote:
thanks to all. i appreciate it.



"Pete_UK" wrote:
If that is in A1, then put this formula in B1:

=PROPER(A1)

Select B1 again and <copy it, then Edit | Paste Special | Values
(check) | OK then <Enter. Then just <copy <paste it over the
original, and delete B1.

(Not quite as easy as Word !!)

Hope this helps.

Pete

On Jul 25, 8:58 pm, Yossy wrote:
I have this "dog, cat, mice"

I want to achieve this Dog, Cat, Mice.

All help appreciated.

Thanks- Hide quoted text -

- Show quoted text -