Hi David

you're absolutely correct ... don't know where my brain was when i typed
that answer:)

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"David McRitchie" wrote in message
...
Would be okay if the only spaces are unwanted
spaces before the the equal sign, but it would be
better to replace space equal sign by equal sign.
so as not to destroy embedded spaces as in
i.e. = A1 & " " & B1

The TrimAll macro on my join.htm page will convert
CHAR(128) to spaces first and then TRIM. Used all the
time as a fixup for bad typing introducing spaces and for
copying tables from web pages where the spaces are
really   (nonbreaking spaces).
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"JulieD" wrote in message
...
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?