On Thu, 2005-05-19 at 23:58 +0200, Bj�rn-Erik Skj�ren wrote: > > -------- Original Message -------- > Subject: Re: [users] Splitting a cell in Calc > Date: Thu, 19 May 2005 23:50:13 +0200 > From: Bj�rn-Erik Skj�ren <[EMAIL PROTECTED]> > To: [email protected] > References: <[EMAIL PROTECTED]> > <[EMAIL PROTECTED]> > > > > I receive one a week a excell spreadsheet with 2000 rows. The cells that > I need to split starts with an item number and is followed up with item > name. I need to sort the rows by item name and not by item number. > Therefore I tough the solution is to splitt the cell (with its content) > between the item number and name > > eks: 123 Bananas > > If somebody could tell me an simple method of inserting a , (or another > field seperator) after the item number (eks 123) I could save the sheet > as an csv and import it back in calc.
Hi, You can do that by insert two new coloumns and using the LEFT and RIGHT functions to extract the strings. e.g. In a new column put =LEFT(A1,3) would give "123". Regards Jonathon -- OOo Tips (RSS) - http://mindmeld.cybersite.com.au/tips.rss OOo Knowledgebase - http://mindmeld.cybersite.com.au/ Cybersite Consulting - http://www.cybersite.com.au/ Training4Linux - http://www.training4linux.com --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
