.txt data that is described as Lat Lon Elevation (meters) and when I export to
.CSV in Excel it puts all data into 1 column. So when I import the data into
QGIS it all dumps into 1 column, and I cannot change the
Y value column names when importing as Delimited Text File. Help!
Assuming that the LAT-LONG-METER field has a consistent number of characters for each entry, you could use right() and (left) to pull apart the text street into new columns, name those what you pleased, and then import them.
You can also save as ".csv" directly from the notepad. Just open your text file (.txt) with Notepad (or Notepad++ or a similar software) and save the file as ".csv". You don't need to save it from Excel. If you still want to save your txt as csv from Excel, after the creation of the csv open it with a text editor and verify which delimiter Excel has created. In case it is not a comma, when importing into QGIS use the custom delimiter and specify the type.