Hello,
I have a problem when I import a csv file into Excel and Access, there are several hundred lines that are imported with 3 blank spaces before the text names in the field. This causes a problem when sorting and running sum totals, as it treats these names as a different spelling. How can I create a macro to take the three spaces out and shift the text to the left 3 spaces?
Thank you in advance!
I have a problem when I import a csv file into Excel and Access, there are several hundred lines that are imported with 3 blank spaces before the text names in the field. This causes a problem when sorting and running sum totals, as it treats these names as a different spelling. How can I create a macro to take the three spaces out and shift the text to the left 3 spaces?
Thank you in advance!