Forum Discussion
HELP with data delimiters
Hi, I have long list of files in .dat format that I want to convert them into excel format. The files have bunch of data separated by delimiters and I need them to be separated by columns in exc...
See if it helps in you case.
https://professor-excel.com/merge-excel-files-combine-workbooks-one-file/
AshaKantaSharma
Thank you for responding!
I'm not trying to merge the files. Rather, I want each text file to be converted to an excel file with text separated in different columns based on their delimiters (i.e semicolon, space, ...)
for example,
Name, orange; time day .dat
to
| Name | orange | time | day | .xlsx
I can do that for one file a time using the text wizard, I'm wondering if there is a way to do that for all of them at once?
Thank you for responding!
I'm not trying to merge the files. Rather, I want each text file to be converted to an excel file with text separated in different columns based on their delimiters (i.e semicolon, space, ...)
for example,
Name, orange; time day .dat
to
| Name | orange | time | day | .xlsx
I can do that for one file a time using the text wizard, I'm wondering if there is a way to do that for all of them at once?