I think you are importing a Text file using data - Importing external text.
If not, then you are pasting the data into the workbook and using Text - To
- Columns. the problem would be the same in either case.

There a numous problems with the Text - to - columns method in excel.
Usually I write my own macros to open a text file and process the data. I
can supply a macro if I had more details about your imput.

A simple solution is to put your code into Notepad and get rid of the extra
Carriage return. Then put the data into excel. I often use Notepad to
filter data berfore moving text from one application to another. Notepad
will remove extraneous invisible character and give you the oportunity to
make modifications as necessary.

"Anthony" wrote:

Hi,
We currently have three laptops working at our office with Excel 2003 on
them one has sp2 and the other two have sp3.
As part of their general usage we export information from another
application to excel for ease of reading, but we have got a problem. With the
SP2 laptop this works fine and the spreadsheet is formatted as we would
expect, but on the two laptops with sp3 the formatting is different where a
cell has information in it and then an Alt+Enter instead of creating a new
line it actually does a hard return and creates a new line.
Can anyone help?
Thanks
Anthony