Hi
I need VBA code to import text file and put it in the format of
1. No spaces
2. Every character in a new column
3. Ignore commas, full stops
As the text to columns 'fixed width' function in excel but saves having to click every column to the end of the text
Thank you