ExcelBanter

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- -   (https://www.excelbanter.com/excel-programming/297328-nbsp%3B.html)

Aaron[_13_]

 

I have a file that I have downloaded to excel from the Web. The format is showing alot of NonBreaking spaces which is not allowing me to SUM the numbers. HOw do I get rid of these after it is in Excel

Thanks
Aaron

JE McGimpsey

 

Check out David McRitchie's TRIMALL():

http://www.mvps.org/dmcritchie/excel/join.htm#trimall

In article ,
"Aaron" wrote:

I have a file that I have downloaded to excel from the Web. The format is
showing alot of NonBreaking spaces which is not allowing me to SUM the
numbers. HOw do I get rid of these after it is in Excel?

All times are GMT +1. The time now is 08:34 PM.