ExcelBanter - Formatting .txt File

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Formatting .txt File (https://www.excelbanter.com/excel-discussion-misc-queries/160907-formatting-txt-file.html)

gator

Formatting .txt File

I have imported a txt file into Excel and there are five txt fields that are
all contained within one xls field. The txt data has several spaces in
between the fields. Is there a way to assign the txt fields to different xls
fields?
--
Gator

Kevin B

Formatting .txt File

Try using TEXT TO COLUMNS on the Data menu.

--
Kevin Backmann

"Gator" wrote:

I have imported a txt file into Excel and there are five txt fields that are
all contained within one xls field. The txt data has several spaces in
between the fields. Is there a way to assign the txt fields to different xls
fields?
--
Gator

All times are GMT +1. The time now is 01:46 AM.