I have a text file of several columns of data not separated by commas (so no CSV) but by one space.

Is there still a way to import that into Excel and have Excel read the spaces as a separate cell?

 

Yup.

Import data and select the space character as the text delimiter.

 

Helpful!


What version of Excel?

 

Also, what color and fabric composition of socks are you currently wearing?

80/20 poly cotton?

 

You are godly.

Excel 2007. Excel 2010 kinda blows on compatibility with some add-ins

I don't wear socks. I wear crocs.

 

Data>Get External>From Text

Select the "delimited" radio button.

Have another martini.

Click "Next"

Make sure the twist is really a twist and not a slice of lemon. Slice sucks...

Select the check box for "space". You will not get a three hour long Grateful Dead drum solo. Trust me here.

Look in the preview window below and see fi the data lines up correctly. If not, rinse and repeat. Of so, paypal me some cookies. Or fax them. I love faxed cookies.

 

It worked perfectly. Thank you.

Left a goggle msg for you :wink:

 

nice work Stogerson

 

Wow, booze rules!