I tried [[:space:]] and that did not work but [:space:]? did.
What is the difference? I'm unclear on that even after reading this thread.
Thanks!
Joelle
Fred Grant wrote:
=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.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
