A little help from the techno-savvy

Simon_Nesbit · 03-10-2006, 07:01 AM

I have a small problem.

I have 'inherited' a collection of .txt files which are lined up fine, but I can't work out how to import them into excel, so I can sort and modify them.

They are set-up with spaces between them, so that they come through straight when inside the < code > .... < /code > tags, but they aren't tab-delimited or comma-delimited.

Any ideas?

Bobble · 03-10-2006, 10:05 AM

When you import them into Excel, there should be the option to do "fixed width" instead of delimited. That will allow you in the next step to define your column widths.

If not when you first bring the file in to Excel, you could bring all the data into a single column of cells and then use the menu item "Data / Text to Columns..." to parse it out by fixed width.

Simon_Nesbit · 03-10-2006, 10:16 AM

Awesome....ta muchly

03-10-2006, 07:01 AM	#1
Simon_Nesbit Minors (Triple A) Join Date: Mar 2004 Posts: 260	A little help from the techno-savvy I have a small problem. I have 'inherited' a collection of .txt files which are lined up fine, but I can't work out how to import them into excel, so I can sort and modify them. They are set-up with spaces between them, so that they come through straight when inside the < code > .... < /code > tags, but they aren't tab-delimited or comma-delimited. Any ideas?

03-10-2006, 10:05 AM	#2
Bobble Hall Of Famer Join Date: Jul 2004 Location: High and outside Posts: 4,054	When you import them into Excel, there should be the option to do "fixed width" instead of delimited. That will allow you in the next step to define your column widths. If not when you first bring the file in to Excel, you could bring all the data into a single column of cells and then use the menu item "Data / Text to Columns..." to parse it out by fixed width. __________________

03-10-2006, 10:16 AM	#3
Simon_Nesbit Minors (Triple A) Join Date: Mar 2004 Posts: 260	Awesome....ta muchly