Caps formular please help

Y

Yossy

I have this "dog, cat, mice"

I want to achieve this Dog, Cat, Mice.

All help appreciated.

Thanks
 
P

Pete_UK

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
 
P

Peo Sjoblom

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
 
Y

Yossy

thanks to all. i appreciate it.

Pete_UK said:
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
Click to expand...
 

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

check value in cell 2
excel and combobox question 0
Merge Cells? 2
How to convert at single colum list into a multi column table 1
countif/sumproduct = criteria with weeknum 2
Searching multiple fields and then print the entire row from resul 2
highlight dependent cells 2
Lookup_finding all the corresponding cell... 5

Top