I have an application that gives me a list of symbols separated by spaces. When copy and paste them to excel they initially get pasted in one cell, and I need to use the import wizard to spread them out in a row.
I want to know if there's a vba command to do these steps for me, so I can include it in a macro.
Thanks