On Fri, 2005-03-11 at 15:36 +1300, Max Quordlepleen 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?
I am not certain what you are saying. I have sent you a spreadsheet that may do what you want. It uses a frozen row. Sorting is the next step I would guess. > -- G. Roderick Singleton <[EMAIL PROTECTED]> PATH tech --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
