Excel 2003 Text to Columns

[fantasmo]

I recently reformatted a PC (Windows XP Pro) and reinstalled Office 2003 Pro. I have never used the feature, but the user routinely pulls a report and opens it from her accounting software into Excel. She then highlights the first column and goes to Data-Text to Columns and separates the data into columns and sizes she can work with. (The data seems to always be recognized as delimited, but she can then select the fixed width option). For some reason, since the reformat, Excel won't pick up the rest of the columns of data within the document. It will only work with one column at a time.

I have tested this sequence on two other computers on the network (one with Office 2003 Pro and one with Office 2007). Both work with no problems. I have installed all of the updates and service packs to the office installation. She can go column by column and use this text to columns feature, but she would rather do it all in one shot.

Thanks in advance for any help.

Fantasmo

 

[RoryA]

I'm not sure I understand. Text to Columns only works on one column at a time.

 

[fantasmo]

That is correct. When I select the first column of data, and choose Data-Text to Columns, it will only pick up that column of data. When I do the same function on other PCs, it then converts the entire page of data. The user also tells me that before the reformat of the PC, it would convert the entire page of data. I'm not quite sure what the difference is between these systems.

Any thoughts?