ExcelBanter - Separating Data Into Multiple Columns

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

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

- - Separating Data Into Multiple Columns (https://www.excelbanter.com/excel-discussion-misc-queries/90832-separating-data-into-multiple-columns.html)

penroma

Separating Data Into Multiple Columns

I am copying a text file into Excel. I need help understanding how to
insert column widths so that all the data in Excel will not be in one
column, but in separate columns.
Thanks in advance!

--
penroma
------------------------------------------------------------------------
penroma's Profile: http://www.excelforum.com/member.php...fo&userid=3425
View this thread: http://www.excelforum.com/showthread...hreadid=546001

Toppers

Separating Data Into Multiple Columns

Look at Data==Text to Columns.

"penroma" wrote:

I am copying a text file into Excel. I need help understanding how to
insert column widths so that all the data in Excel will not be in one
column, but in separate columns.
Thanks in advance!

--
penroma
------------------------------------------------------------------------
penroma's Profile: http://www.excelforum.com/member.php...fo&userid=3425
View this thread: http://www.excelforum.com/showthread...hreadid=546001

DCSwearingen

Separating Data Into Multiple Columns

Depends on the origin of the text as to the best way to accomplish it.

I have always had the most success saving the text as a text file
(Notepad) and then importing the text file into Excel.

The assumption is that the text is delimited in some fashion?

From the Excel File Open dialog, select Text files from the drop-down
at the bottom of the dialog and select your text file.

The text import wizard will guide you through the process, you just
need to know if you want fixed width columns or if delimited.

--
DCSwearingen

Getting old, but love computers.
------------------------------------------------------------------------
DCSwearingen's Profile: http://www.excelforum.com/member.php...o&userid=21506
View this thread: http://www.excelforum.com/showthread...hreadid=546001

penroma

Separating Data Into Multiple Columns

Thank you!

--
penroma
------------------------------------------------------------------------
penroma's Profile: http://www.excelforum.com/member.php...fo&userid=3425
View this thread: http://www.excelforum.com/showthread...hreadid=546001

All times are GMT +1. The time now is 02:45 AM.