ExcelBanter - Put Wrap Text in Text File into 1 Row

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Put Wrap Text in Text File into 1 Row (https://www.excelbanter.com/excel-discussion-misc-queries/169968-put-wrap-text-text-file-into-1-row.html)

carolini

Put Wrap Text in Text File into 1 Row

I have a text file that the data wraps into a second line. How can I get the
data all on one line? See sample below: Any help would be appreciated!
Thanks!

FR#Acct # Name
Status Phone Address

001-008705 Smith, J *13A Jones PL
ACT (555)555-5555 BRONX NY 10475-3903

001-016770 Harris, H *22A Jones PL
ACT (555)555-5555 BRONX NY 10475-3904

All times are GMT +1. The time now is 04:41 AM.