Maybe I haven't been specific enough in my searches on this website and throughout the Internet world...
I have written a VBA in Excel 2007 to open a text file (not necessarily a .txt, but you can view it using word/notepad) and put it into another sheet in the workbook. Unforunately I cannot properly sort this data into columns because there aren't consistent delimiters and I have multiple spaces in different places. I understand Trim only works for removing from the beginning and end of the string. I've come across many codes and functions but nothing has really worked the way I need them to work. I still need to keep one space in between words/numbers so I can sort them into columns for later analysis. This is the part of my code that I can't get to work properly....
Above this I have ActiveSheet.Range("A:A").Select so it selects the column that I need to apply this to.
Am I missing something? Is this too complicated?
Thank you!
Bookmarks