Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multiple columns of data into one long column | Excel Discussion (Misc queries) | |||
filtering unique in multiple columns | Excel Worksheet Functions | |||
Data in table, may need to convert to columns with OFFSET? | Excel Discussion (Misc queries) | |||
merge data from multiple columns to single column | Excel Worksheet Functions | |||
Drop-down selection fills data across multiple columns | Excel Discussion (Misc queries) |