I have a file of raw data coming out of an access database weekly. There are a number of columns which I need to run the "Text to Column" on. Is there a way to automate this? All of the headers needing to be converted have the % symbol in the header string.
So I need to do something like
if (column header contains a '%') then text to column for each column where the header is not blank.
Is this something that can be done?
Thanks ahead of time for any help, it is greatly appreciated!