When I copy and paste information from a website to excel - the data that I
have copied from the website was center justified so spaces are copied. One
of the columns of data is currency so the $12.50 has three spaces before the
$. I cannot apply any formatting to the cells with the spaces in there.
When I delete the spaces everything is fine and my colums total correctly.
I want to remove all leading spaces form all cells in the worksheet.