How to prevent wrapping when importing text file

[STIRRELL]

Hi, I am using the import function to import a text file. But the file is wrapping the text and no matter what I try I can not stop the wrapping. as
I could not see anything specific that was causing the wrapping. I am trying to get the information for each record on one row. Any help would be appreciated.

Sample 1
Line 889: Email - "John.Doe@sample.com" Employee ID - "2793"
No User or Employee record changes.
Sample 2
Line 920: Email - "Jane.Doe@sample.com" Employee ID - "2867"
Warning - The 2nd approver email John.Doe@sample.com does not exist. If the user is successfully created later in this file, it should be assigned.
No User or Employee record changes.

Thank you so much,
Sharon

 

[XLfriend777]

Hi STIRRELL - Have you tried copy and paste-special - values? It sounds like import is taking the underlying formatting and adding in the unwanted wrapping. Sometimes I have gotten around this by using paste special values which does not include any formatting. Hope this helps get you started.

 

[Marc L]

Hi,​

​

just well format the cells after the importation …​