Thread
:
Downloaded Report
View Single Post
#
6
Posted to microsoft.public.excel.misc
Sandy Mann
external usenet poster
Posts: 2,345
Downloaded Report
I can onlt assume that it was because I did not include the third argument
of the SUBSTITUTE() but it works fine for me in XL97. Try:
=--TRIM(SUBSTITUTE(A1,CHAR(160),""))
--
HTH
Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings
Replace @mailinator.com with @tiscali.co.uk
"Erika" wrote in message
...
I tried this formula and the result I got was FALSE. I am not sure what
that
means?
"Sandy Mann" wrote:
Quite often downloaded data will have non-breaking spaces Character 160
attached to them that TRIM() does not remove. Try:
=--SUBSTITUTE(A1,CHAR(160),)
--
HTH
Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings
Replace @mailinator.com with @tiscali.co.uk
"Erika" wrote in message
...
I have a report that I download into excel - it has a currency value and
when
I try to do a calculation on it - it will not work. I noticed that the
values are not formatted as a number so I changed that. I also noticed
there
are some extra spaces in the field I tried the clean function, the trim
function and convert text to columns to attempt to isolate and remove
the
extra spaces - none seemed to work.
Any other suggestions to get these converted to text so calculations
will
work?
Reply With Quote
Sandy Mann
View Public Profile
Find all posts by Sandy Mann