importing a .csv so data on new lines?

  • Thread starter Thread starter biff
  • Start date Start date
B

biff

I have a csv file. The data is separated by commas and each record is on a
new line. Is there any way to import the data into Word so that the data
that is separated by commas in the csv appears on a new line within Word
while each record is separated by a blank line?
 
Well you could just copy paste your data into Word and then do two find
replace operations:

1)Replace "^p" by "^p^p"
2)Replace "," by "^p"

If you don't want paragraphs but rather soft enters within a record, you
could use "^l" for the replacement option in the second part.

Yves
 
Thank you both for the helpful suggestions.

Yves Dhondt said:
Well you could just copy paste your data into Word and then do two find
replace operations:

1)Replace "^p" by "^p^p"
2)Replace "," by "^p"

If you don't want paragraphs but rather soft enters within a record, you
could use "^l" for the replacement option in the second part.

Yves



.
Click to expand...
 
Back
Top