All you need to do is extract the item name from the first column into a new column and sort by that one. The easiest way would be to insert a new column next to the item name/number column. Assuming that the item column is 'B', type this formula in the first row of the inserted column
=Mid(B1,find(" ";B1)+1;99)The result should be the contents of B1 to the right of the space that follows the item number.
tc
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.
G. Roderick Singleton wrote:
On Thu, 2005-05-19 at 18:21 +0200, BjÃrn-Erik SkjÃren wrote:
Hi. I am looking for a solution for splitting a cell in Calc into two cells. The original cell is not merged
Anybody that can help me?
Splitting is only available in Calc where cells were previously merged.
Why not simply insert a new column where needed?
------------------------------------------------------------------------
--------------------------------------------------------------------- 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]
