In news:[EMAIL PROTECTED], Joelle Tegwen <[EMAIL PROTECTED]> typed: > 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 just tried it; I entered things like "12 34 56" (no quotes) in a couple of cells, and used your procedure, using the space bar in the "Search for" field, and I put nothing at all in the "Replace with" field. Don't know if it matters, but "Search in" was set to formulas. It worked fine. Using "[:space:]" failed. Is it possible that the spaces you are trying to replace are not really spaces? Have you tried replacing something other than a space with that procedure? Bob Long --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
