how to import a text file into excel?

[deadeye123]

I have a text file that has headers. the headers and data are separated by a semi colon in my text. when i import the text file, most of the data is pasted into Column A. i need to separate each header and paste it into it's own column. i tried importing the the text, i used comma, space..and couldn't figure it out. any help?

 

[Beyond_avarice]

Data Tab > Get external Data > From Text> Select Delimited > Check the "Semicolon" as a delimiter.

Delimiters are what separate each value. In this case you have semicolon's.

 

[Myrko]

Data tab/From Text, Select file, Delimited, make sure you check "Semicolon" box in the next step (and any other delimiter used for the data underneath headers).