how to create 1st letter of every word capital ? - GoFuckYourself.com

cooldude7 · 09-07-2011, 11:02 PM

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.

DBS.US · 09-07-2011, 11:11 PM

mattz · 09-07-2011, 11:20 PM

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

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

cooldude7 · 09-07-2011, 11:22 PM

Quote:

Originally Posted by mattz

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.,

L-Pink · 09-07-2011, 11:23 PM

Quote:

Originally Posted by cooldude7

thanks , i am already working on it.,

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

.

Tempest · 09-07-2011, 11:25 PM

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

cooldude7 · 09-07-2011, 11:28 PM

Quote:

Originally Posted by Tempest

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

cooldude7 · 09-07-2011, 11:30 PM

Quote:

Originally Posted by Tempest

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

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

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

cooldude7 · 09-07-2011, 11:34 PM

just noticed its called capitalize and found something

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

sucks i am using office xp.

Tempest · 09-07-2011, 11:37 PM

Quote:

Originally Posted by cooldude7

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

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

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

seeandsee · 09-08-2011, 12:51 AM

there is no such option in word? strange

cooldude7 · 09-08-2011, 12:53 AM

Quote:

Originally Posted by seeandsee

there is no such option in word? strange

yes there is "capitalize each word"

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

Mr Pheer · 09-08-2011, 02:46 AM

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

ottopottomouse · 09-08-2011, 03:51 AM

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

Mr Pheer · 09-08-2011, 06:41 PM

You're welcome

PromoterX · 09-08-2011, 08:35 PM

Code:

Sub Proper_Case()

'This will make the first letter of the text within any selection of 
'cells uppercase.

For Each x In Selection
x.Value = Application.Proper(x.Value)
Next

End Sub

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

cooldude7 · 09-08-2011, 09:58 PM

Quote:

Originally Posted by ottopottomouse

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

those text lines are just for titles...

cooldude7 · 09-08-2011, 10:07 PM

Quote:

Originally Posted by Mr Pheer

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

thanks a lot.

cooldude7 · 09-08-2011, 10:09 PM

Quote:

Originally Posted by PromoterX

Code:

Sub Proper_Case()

'This will make the first letter of the text within any selection of 
'cells uppercase.

For Each x In Selection
x.Value = Application.Proper(x.Value)
Next

End Sub

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

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

thanks for your reply.

96ukssob · 09-08-2011, 10:11 PM

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"

mikephat · 09-08-2011, 10:28 PM

in word:

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

harvey · 09-08-2011, 10:41 PM

Doug E · 09-09-2011, 01:24 AM

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

text-transform: capitalize;

09-07-2011, 11:02 PM	#1
cooldude7 Confirmed User Industry Role: Join Date: Nov 2009 Location: Heaven Posts: 4,306	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.

09-07-2011, 11:11 PM	#2
DBS.US Geo Cities Industry Role: Join Date: Aug 2003 Location: North Captiva Island, Florida USA Posts: 11,828	__________________ Make a Free Chaturbate White Label site in 34 minutes and be making money tonight

09-08-2011, 12:51 AM	#11
seeandsee Check SIG! Industry Role: Join Date: Mar 2006 Location: Europe (Skype: gojkoas) Posts: 50,945	there is no such option in word? strange __________________ BUY MY SIG - 50$/Year Contact here

09-08-2011, 03:51 AM	#14
ottopottomouse She is ugly, bad luck. Industry Role: Join Date: Jan 2010 Posts: 13,177	Capitalising Every Word Makes For The Most Horrible Text To Read. __________________ ↑ see post ↑ 13101

09-08-2011, 08:35 PM	#16
PromoterX Confirmed User Industry Role: Join Date: Sep 2010 Posts: 949	Code: Sub Proper_Case() 'This will make the first letter of the text within any selection of 'cells uppercase. For Each x In Selection x.Value = Application.Proper(x.Value) Next End Sub Why re-invent the wheel.... codes out there for the taking people.

09-07-2011, 11:20 PM	#3
mattz Confirmed User Industry Role: Join Date: Dec 2001 Location: AZ Posts: 7,697	a simple search brought up this page with codes...not sure if it will help http://php.net/manual/en/function.ucfirst.php

09-07-2011, 11:25 PM	#6
Tempest Too lazy to set a custom title Industry Role: Join Date: May 2004 Location: West Coast, Canada. Posts: 10,217	use editplus.. then select all the text and press Ctrl+Shift+U.

09-07-2011, 11:34 PM	#9
cooldude7 Confirmed User Industry Role: Join Date: Nov 2009 Location: Heaven Posts: 4,306	just noticed its called capitalize and found something http://office.microsoft.com/en-us/wo...010210665.aspx sucks i am using office xp.

09-08-2011, 02:46 AM	#13
Mr Pheer Living inside your head. Industry Role: Join Date: Dec 2002 Location: In your AirBNB Posts: 20,414	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

09-08-2011, 06:41 PM	#15
Mr Pheer Living inside your head. Industry Role: Join Date: Dec 2002 Location: In your AirBNB Posts: 20,414	You're welcome

09-08-2011, 10:11 PM	#20
96ukssob So Fucking Banananananas Industry Role: Join Date: Mar 2003 Location: If I was in your ass you'd know it Posts: 12,991	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" __________________ Email: Clicky on Me

09-08-2011, 10:28 PM	#21
mikephat Registered User Industry Role: Join Date: Mar 2008 Posts: 33	in word: Select text, Format -> Change Case -> Title Case

09-08-2011, 10:41 PM	#22
harvey Confirmed User Industry Role: Join Date: Jul 2001 Location: 127.0.0.1 Posts: 9,266	__________________ This post is endorsed by CIA, KGB, MI6, the Mafia, Illuminati, Kim Jong Il, Worldwide Ninjas Association, Klingon Empire and lolcats. Don't mess around with it, just accept it and embrace the truth

09-09-2011, 01:24 AM	#23
Doug E Confirmed User Join Date: Sep 2005 Posts: 511	op wants word or excel but for anybody looking for a css option.. text-transform: capitalize;