You could use
Find and replace
regular expressions
Search for [:digit:]*
replace with &,this will find a number in your cells and replace it with the same number and a comma.
Doug Stewart
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]
