If you often have to convert values from Excel files into SQL filter lists for investigation purposes, this VBA function will save you a lot of time.
Thanks for this function go to Sascha Hombach a highly skilled IT Consultant, who initially developed it for HP ALM filter Strings. I only adjusted it for the use case described above.
The function can be called as follows, in order to copy a filter list into the clipboard.
This code snippet is not tested in copied form.
The functions for copying data into the clipboard have been taken from the following URL.