I hope this isn't the third copy of this, but my web mail isn't showing a sent reply, so thanks again for the answer.
> -------- Original Message -------- > Subject: Re: [users] Calc: (De)concatenation questions > From: Paul <[EMAIL PROTECTED]> > Date: Fri, March 11, 2005 3:56 pm > To: [email protected], [EMAIL PROTECTED] > > 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]
