I'm not doing anything to the data other than copying and pasting from outlook to notepad to excel. The data is delimited by spaces. The reason there is sometimes spill over of the company names onto the next line is purely a result of how the data is emailed to me. Some company names take two lines in the email and the formatting just copies into excel that way. I don't understand what you mean by vblF and vbCrLF characters causing the wrapping. Can you elaborate? I just need the data to go from the first example to the second example.