Hi,
I'm working through the Power Pivot course, and having trouble with lesson 3.06 - Importing text files. Even though I've set a delimiter, the import brings in all the columns as a single field (i.e., the delimiter does not seem to be working). I tried the same exercise with another text file that is [|] delimited, with the same result. Help!
Hi Michelle,
With the pp_3_returns.txt file did you choose the 'Tab' column separator in the 'Table Import Wizard'?
If you're still having problems with this delimiter please provide more information:
- What version of Excel are you using?
- Please provide a screenshot of the Table Import Wizard screen and the other file you tried so I can text on my PC.
Thanks,
Mynda
Hi
I have the same problem! The text file has a comma between the two elements. The raw file each row is contained between double quotes at the start and finish. I've tried all the delimiters without success.
I'm using Microsoft 365 with automatic updates.
A screen print is attached.
Geoff
OK just discovered the .csv note under the video!!! Will try that! Thank you! Geoff.