VBA Code to delete trailing spaces:

All,
I have a spreadsheet that has tons of numbers in Columns E & F that have trailing spaces (on the right side). This is making it impossible to format the cells as currency.

I've tried Find & Replace (searching for " " and replacing with ""), I've tried using the trim function- neither worked.

I guess what I'm looking for is just a piece of VBA code I can paste into a larger Macro that will remove blank spaces from the right side of all values in those columns. There will never be more than 1 space, and the change can be made for all values in those rows.

Thanks in advance, I really appreciate it.

Chad

Try one of these
use substitute function. You may have " ", not space, try to replace them with nil.

OR

Try to multiply both columns by 1. Put in 1 in any cell, then copy that cell, paste special multiply and see if they are converted in to numbers

Hmmm. I'm not sure if it's a blank space or Nil. Could you take a look at the attached spreadsheet and let me know what I have and what the best way to get rid of it would be?

Thanks Again

Try the attached.

That works- awesome. Thanks for putting that together for me!