how to create 1st letter of every word capital ?
 

in word or in excel

i have about 489 lines with data and i want to create 1st letter of every word capital ..

how can i do that ?

help needed.

thanks for your time.

a simple search brought up this page with codes...not sure if it will help

http://php.net/manual/en/function.ucfirst.php

thanks , i am already working on it.,

Careful, don't get carpal tunnel from the shift key.

.

use editplus.. then select all the text and press Ctrl+Shift+U.

just downloading., i was doing something with this http://www.php.net/manual/en/function.ucwords.php

damn, this is the best motherfucker application., work done.,

i love you., thanks for saving me from coding.:thumbsup

just noticed its called capitalize and found something

http://office.microsoft.com/en-us/wo...010210665.aspx

sucks i am using office xp.

Yep, editplus rocks.. Been using it for many years.

there is no such option in word? strange

yes there is "capitalize each word"

http://office.microsoft.com/en-us/wo...010210665.aspx

Use Ultra Edit, highlight the text then hit F5

Or just go here, paste the shit in the window and hit the correct button.
http://textmechanic.com/Letter-Case-Converter.html

Capitalising Every Word Makes For The Most Horrible Text To Read.

You're welcome :)

Why re-invent the wheel.... codes out there for the taking people.

those text lines are just for titles...

thanks a lot. :thumbsup

i am kind of new in coding so, this is a bot ccomplicated for me.,

thanks for your reply.

holy christ, can't believe no one has answered this...

assume cell A1 has the following text "blah blah blah i like cock."
the formula in cell B2 =proper(A1) will = "Blah Blah Blah I Like Cock"

in word:

Select text,
Format -> Change Case -> Title Case

op wants word or excel but for anybody looking for a css option..

text-transform: capitalize;