jaffamuffin
New member
- Joined
- Sep 5, 2013
- Messages
- 6
- Reaction score
- 0
- Points
- 0
Hi All
What I have routinely done for years now is create tab delimited text file (automatically using a script). Some of these 'records' have spaces within, e.g a date<tab>firstname<space>lastname<tab>etc
The file is appended to and after about maybe 4-6 lines I then copy and paste that into an excel spreadsheet.
The tabs ensure that the data lands in the right column / cell and everything is great. I don't need to mess about with text to columns or anything, just a simple copy paste. This is WinXP version 2002 SP3 and excel 2003 11.8347.8403 SP3
But when I use the same excel file, the same text file, and try to paste into using Win7 x64 and excel 2003 (11.8105.8107) SP2 it splits the pasted data on the spaces and the tabs....
How do I stop it from doing this ?
My colleague has excel 2007 and it works as it should for him (like on my XP)
I'm going to update my excel install to SP3 in the meantime.
thanks
What I have routinely done for years now is create tab delimited text file (automatically using a script). Some of these 'records' have spaces within, e.g a date<tab>firstname<space>lastname<tab>etc
The file is appended to and after about maybe 4-6 lines I then copy and paste that into an excel spreadsheet.
The tabs ensure that the data lands in the right column / cell and everything is great. I don't need to mess about with text to columns or anything, just a simple copy paste. This is WinXP version 2002 SP3 and excel 2003 11.8347.8403 SP3
But when I use the same excel file, the same text file, and try to paste into using Win7 x64 and excel 2003 (11.8105.8107) SP2 it splits the pasted data on the spaces and the tabs....
How do I stop it from doing this ?
My colleague has excel 2007 and it works as it should for him (like on my XP)
I'm going to update my excel install to SP3 in the meantime.
thanks