I copied a table with numbers from a webpage. I pasted the table in Excel and couldn't manipulate the numbers. After copying the cells in MS-Word with formating marks ON, I noticed they had non-breaking spaces preceding the numbers. I was able to delete them in MS-Word and paste them back into my spreadsheet as numbers. Is there anyway to remove these non-breaking spaces from my spreadsheet within Excel.
I saw another post that had a formula:
=VALUE(TRIM(SUBSITUTE(webValue,CHAR(160)," "))) * 1000000
to do something like this, but I have no idea how to apply it.
Can anyone help? Thanks.
I saw another post that had a formula:
=VALUE(TRIM(SUBSITUTE(webValue,CHAR(160)," "))) * 1000000
to do something like this, but I have no idea how to apply it.
Can anyone help? Thanks.