Importing delimited strings

BarrettM · May 16th, 2002, 04:22 AM

I have a text delimited string which is about 20 x A4 pages long and am trying to import it. It partially imports the file as far as col IV (the 1st row of excel).
Is this a limitation or does anyone have any ideas how to do this.

Thanks all

Jack in the UK · May 16th, 2002, 04:41 AM

Hi Barrett

Col IV256 is max that’s 256 = Col IV in R1C1 or R1C256

the limits are

Cols IV = 256
Rows = 65636

From what you say can you not twist it so it other way round so uses 65536 rows as if columns...

PS Cool name where is it from, first name.

BarrettM · May 16th, 2002, 05:38 AM

I can't twist the data as you suggest, so I really need to know if this one of the limitations of excel

Jack in the UK · May 16th, 2002, 05:49 AM

unless you can split over 2 or more sheets suggest access and link excel in

May 16th, 2002, 04:41 AM	#2
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,065	Hi Barrett Col IV256 is max that’s 256 = Col IV in R1C1 or R1C256 the limits are Cols IV = 256 Rows = 65636 From what you say can you not twist it so it other way round so uses 65536 rows as if columns... PS Cool name where is it from, first name. __________________ Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you"

May 16th, 2002, 05:49 AM	#4
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,065	unless you can split over 2 or more sheets suggest access and link excel in __________________ Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you"

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 16th, 2002, 04:22 AM	#1
BarrettM Board Regular Join Date: Mar 2002 Location: Northern Ireland Posts: 113	I have a text delimited string which is about 20 x A4 pages long and am trying to import it. It partially imports the file as far as col IV (the 1st row of excel). Is this a limitation or does anyone have any ideas how to do this. Thanks all

May 16th, 2002, 05:38 AM	#3
BarrettM Board Regular Join Date: Mar 2002 Location: Northern Ireland Posts: 113	I can't twist the data as you suggest, so I really need to know if this one of the limitations of excel