On Wed, 2005-11-23 at 12:57, Joelle Tegwen wrote:
> Feeling pretty dumb here but I can't seem to make this work.
>
> [Windows XP: OO 2.0: Calc]
>
> I'm importing some data from an html table on a regular basis and I need
> to be able to do a find and replace to remove extra spaces from numbers
> so they can be acted on as numbers.
>
> However when I do the find and replace with:
> Find [:space:]
> Replace [null]
> [selected] Current selection only
> [selected] Regular Expressions
>
> I get a message that the search string wasn't found
> I also tried just using [press space bar here] and that too failed.
>
> I feel like I'm missing something obvious but I wasn't able to figure it
> out from the help.
>
> Could someone point me in the right direction?
>
> Thanks
> Joelle
>
>
> ---------------------------------------------------------------------
=VALUE(REPLACE(A1;FIND(" ";A1);1;"")) would fix a string that had one
blank in it and convert it to a number.
Using find and replace, I was able to do it using [:space:]? in the find
field and leaving the replacement field blank.
--
Fred
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
