Hi All,
Hopefully someone can help me a bit with this query. I'm currently working on an EXCEL VBA macro which will:
1. import a text file into EXCEL
2. trim all cells (the text file has white spaces around all text strings)
3. reformat column headers
4. remove blank rows (blank rows appear...