Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
txt to excel data beyond 256 column restriction
Hi,
I am a researcher and encountered a small problem, I will be grateful if some one can help me to solve my problem. I have some genetic data (character) in text file. There are 1600 columns of data and 2000 rows. When I import data in to excel its taking only 256 columns. Using help menu I realized it can only take maximum 256 columns. But, is there a way I can import data in to different sheets (7), each sheet taking 252 columns, where first 2 columns are ID (keys). In order to run analysis I need this data in excel format, it doesn't matter even if it is in different sheets. If any one wants to look at data, please let me know I can send a sample of all columns and couple of rows. Thanks and appreciate any help. Prasad |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Validation Restriction Referencing other Workbook | Excel Worksheet Functions | |||
numeric data with restriction of data length | Excel Discussion (Misc queries) | |||
Overcoming the restriction of 7 nested IFs in Excel XP. Is it possible? | Excel Worksheet Functions | |||
Data Validation - Restriction | Excel Discussion (Misc queries) | |||
add restriction in Excel | Excel Worksheet Functions |