Thread
:
how to create 1st letter of every word capital ?
View Single Post
09-08-2011, 10:11 PM
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
96ukssob
View Public Profile
Visit 96ukssob's homepage!
Find More Posts by 96ukssob