If you're dealing with numbers stored as text (have extra spaces) it might be
better to use the VALUE function to convert the text to a number.

Or, note that if you have " 500 " in A2 formatted as text, you can still
have another cell have
=A2/100
and it will show correct answer (5)
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Dowitch" wrote:

I've been using Trim to delete extra spaces from fields that contain imported
data. Today I tried to use it on data that I'd copied from a webpage and
inserted into a spreadsheet, but it wouldn't take off the blanks after the
numbers. Am I mis-using the function? These were numbers that I'd copied as
a bulk which 'self-segregated' into individual cells. I then re-copied them
changing from colums to rows using Paste-Special. Then I tried to use Trim,
but it had no effect. I needed to remove the spaces so that I could divide
the numbers by 100.