Try 'proper'. This will capatilise first letter of each word. Paul
On Fri, 11 Mar 2005 15:36:28 +1300, Max Quordlepleen <[EMAIL PROTECTED]> wrote: > Here's the situation: > I have a list of names, imported from another file, that looks like > this: > http://maxqnzs.com/screenshots/initcaps.jpg > > Since Calc doesn't offer a "Title" option for the case of the cells, I > was wondering if I could separate the initial letters into a new > column, change the case of those columns to uppercase, then merge the > cells back together so that "homer simpson" becomes first "H" "omer" > "S" "impson" then "Homer Simpson". How would I go about doing this? > > -- > noho ora mai, ka kite ano > http://maxqnzs.com/References.html > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
