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
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