View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Yossy Yossy is offline
external usenet poster
 
Posts: 127
Default 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