I am developing an application that reads large text files (>100,000
rows) and coverts it into meaningful database. Some of the data streams
runs into multiple rows on the text file. If the strings from all the
rows (Say 10 rows) are concatinated and stored in a cell, the data
becomes a single line string. I still want to retain it as 10 rows (or
lines) in the cell, so that I can display them on my VBA screens as 10
lines in a text box.
Can some one suggest what can be done to this 10 lines of input text
replicated and stored as is on a cell(instead of concatinating into a
single string/line). Basically, I would like to see the lines in the
cell as we would write multiple lines of text scrolling to new line by
using alt+enter.