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 (permalink)
Simon_Nesbit Minors (Triple A) Join Date: Mar 2004 Posts: 254 Thanks: 0 Thanked 9x in 9 posts	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 (permalink)
Bobble All Star Starter Join Date: Jul 2004 Location: High and outside Posts: 1,199 Thanks: 14 Thanked 40x in 19 posts	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. __________________ Markus, please add: 1. Quick-play to RISP 2. Persistent button assignments (button 4 should always be "Steal 2nd") Thank you.

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

03-10-2006, 10:16 AM	#3 (permalink)
Simon_Nesbit Minors (Triple A) Join Date: Mar 2004 Posts: 254 Thanks: 0 Thanked 9x in 9 posts	Awesome....ta muchly