at correspondence column cell, build this formula
=VALUE(SUBSTITUTE(A2,",",""))
Copy down if more than 1, Then copy and paste special value to convert the
formula back to value. Format cell as 1000 separator.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
