I am trying to gather data from a form and then ultimately have it update in an Access database. I currently am able to pull all the data into a text file.
"XX.XX.XXX", "CHOOSE COMPLIANCY", "CHOOSE IMPACT", "CHOOSE PERSON", "CHOOSE PERSON", "CHOOSE DATE", "CHOOSE STATUS", "CHOOSE DATE", "Line 1
Manual return Line 2",
Everything is fine except the last field on my form is one that has multiple paragraphs with user returns. When I import the fields into excel it assumes each line is a new entry so the line where it says line 2 goes into a different column. Is it possible to get where it says Line 1 and Line 2 into the same cell?
"XX.XX.XXX", "CHOOSE COMPLIANCY", "CHOOSE IMPACT", "CHOOSE PERSON", "CHOOSE PERSON", "CHOOSE DATE", "CHOOSE STATUS", "CHOOSE DATE", "Line 1
Manual return Line 2",
Everything is fine except the last field on my form is one that has multiple paragraphs with user returns. When I import the fields into excel it assumes each line is a new entry so the line where it says line 2 goes into a different column. Is it possible to get where it says Line 1 and Line 2 into the same cell?
Last edited:
