Ah, ok thanks. I must have mis-remembered :)
--
Kevin Vaughn


"Dave Peterson" wrote:

I've never had to save the workbook--but data|text to columns|delimited (uncheck
all the options) does it nicely.



Kevin Vaughn wrote:

Another possible explanation. I am taking this from, I believe, posts by
Dave Peterson on the subject. Apparently, once you do the Text to Columns,
Excel will remember your criteria, and then if you Paste something similar
into your spreadsheet, Excel will parse that data for you. IIRC, the
solution, if you don't want this to happen is to do another text to columns
and clear out all of the settings (and I believe save your worksheet.)

I apologize for any inaccuracies as I am doing this all from memory.
--
Kevin Vaughn

"blakrapter" wrote:


Something really weird just happened... I run a website that I update
inventory on daily. To do that, I copy my suppliers inventory txt file
(semicolon delimited), paste it into my spreadsheet, and then use the
text to columns function to update everything. Well, today, when I
copied and pasted the txt file, it automatically converted it from text
to colulmns w/o me telling it to. Why??? Thats pretty cool because it
saved me time, but why did it do it and what if I don't want it to
automatically convert the data?


--
blakrapter
------------------------------------------------------------------------
blakrapter's Profile: http://www.excelforum.com/member.php...o&userid=28926
View this thread: http://www.excelforum.com/showthread...hreadid=511123



--

Dave Peterson