Hi

select the formulas and choose edit / replace
in the find what box press your space bar
leave the replace with box empty

press Replace All

NOTE: when trying something new like this it is always a good idea to do it
on a copy of your workbook first ... just to ensure that the results you get
are the results you expect.

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"kan2953" wrote in message
...
I have a leading space in my formula, which is causing it not to function.
How do I get rid of it?