Re: [libreoffice-users] Converting text to numbers

Hi Gérard,

My example is with spaces.. They are numbers like     "3.51        "

Using Find&Replace, with regular expressions checked , searching for 
*[:space:]?$*  , replacing with nothing removes spaces.

But this is can be a hard step for regular users. And again, they say me 
"ms excel does it, what is this now"  :)





On 07.12.2010 15:05, Gérard Fargeot wrote:
> > Arda Tunccekic wrote (07-12-10 13:27)
> >
> > - Now type "1.22 " , "2.4 ", "3.51 " in the first 3 rows.
>
> With or whithout the " ?
>
> Using Find & Replace, Regular expression checked
> Without the "
> Search : .*
> Replace : &
>
> With the "
> Search : "(.*)"
> Replace : $1
>
> Gérard

--
Unsubscribe instructions: E-mail to users+help@libreoffice.org
List archive: http://www.libreoffice.org/lists/users/
*** All posts to this list are publicly archived for eternity ***