Excel Randoming Becoming More Efficient

B

blakrapter

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

Gary L Brown

Sounds like your supplier changed the extension of the file you were
importing to '.csv' [comma separated values]. When Excel sees this extension
(Example: MyFile.csv) it automatically tries to import it as it sees fit.
The good part is that it is automatic, the bad part is that because it's
automatic, you have no input into how you want the data to be parsed and
displayed. The only way to change this behavior is to change the extension
of the text file from .csv to something else such as '.prn', '.txt' or
whatever.
HTH,
 
K

Kevin Vaughn

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

Dave Peterson

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

blakrapter

Thanks for the info. The extension is correct. It is txt. How can
import it and change the way it converts the text to columns? Ever
time I paste from a txt document, it does it automatically, whic
separates the data, thus, giving me nothing to convert.

Thank
 
D

Dave Peterson

If you're just copying and pasting, then you'll have to do one of those "dummy"
data|text to columns to make excel forget your previous data|text to columns.
 
Top