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