How do I get a txt file to go to excel and have the columns work?

M

Michele

I have gotten the txt file to excel but all the columns are separated but I
can't move them or create charts from them or change the column format.
 
E

Eva

Try if your numbers are really numbers then (=type() (1=number, 2-text)
if you have a text format use funciotn =value()
Eva
 
Top