delete all formatting after last cell character
Posted on 2013-06-12
I have a spreadsheet with 1000 email addressed imported into it. However, they do not have the underlining nor do they operate as an email. I discovered that there is extraneous formattingin the cells that prevents me from using the emails.
I would like to have some vba code that steps through each cell in the usedrange and delete all formatting after the comma ending the emal address
Is it possible using delete or truncate to get rid of the extraneous formatting on the right side of the cell? If so , please let me know how