Hello,
I try to copy and paste from a website to a excel spreadsheet....but the numbers are some how corrupted? you can't do any formulas on them. please teach me how to correct this, see attachment.
thanks
Hello,
I try to copy and paste from a website to a excel spreadsheet....but the numbers are some how corrupted? you can't do any formulas on them. please teach me how to correct this, see attachment.
thanks
You probably have some dirty data.
Try in C10 copied down...
=TRIM(CLEAN(SUBSTITUTE(B10,CHAR(160)," ")))+0
HTH
Regards, Jeff
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks