Hi,
How do you trim selected cells using a macro wherein all special characters and spaces(only infront and at the end, not including the middle space) are removed and the value that is left are only letters and numbers?
Example:
" john3smith.- " will be "john3smith"
"my2data-*&saved " will be "my2datasaved"
"sample3 [info#@" will be "sample3 info"
Bookmarks