There is no function out of the box for this. It can be achieved using a publicy released macro found here: http://www.ooomacros.org/user.php
/paul On 4/28/05, Bob Cataldo <[EMAIL PROTECTED]> wrote: > I am trying to figure out how to convert text to columns in an Open > Office Calc (spread sheet). > > for example: > I want to take a cell which has name ( first and last ) and split it > into 2 ( or more ) columns of First Name and Last name - use the space > as a separator. > > or take an e-mail address and use the @ as a separator. > > Any suggestions would be appreciated. > > Bob Cataldo > > --------------------------------------------------------------------- > 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]
