When I try to save a long list in Excel as a CSV comma delimited it works for the first 17 rows and then stops. Why and how I can fix it?
It puts commas after the data in the first 17 rows and then it doesn't any more. I tried removing the 18th row in case it had bad data in it, but the next row had the same problem
Sample data:
201735,,,,,,60286214,,Anna ,,,07,,,,9999,,,,,,,,,,,,,,,,,344446,,,,,,11111111,,C Lxxxxxxd-Wilson,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, ,,,07,,,,295,,,,,,,,,,,,,,,,,725002,,,,,,11111111,,xxxxxxxxxxxxxx