Welcome to MacForumz.com!
FAQFAQ      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

importing space and/or comma delimited file

 
   Macintosh computer (Home) -> Excel RSS
Next:  iPhoto 08 "modified" folder?  
Author Message
Noah Garrett Wallach

External


Since: Oct 17, 2007
Posts: 1



(Msg. 1) Posted: Wed Oct 17, 2007 1:23 pm
Post subject: importing space and/or comma delimited file
Archived from groups: microsoft>public>mac>office>excel (more info?)

How might I import a space delimited file into excel?
How might I import a comma delimited file into excel?

 >> Stay informed about: importing space and/or comma delimited file 
Back to top
Login to vote
Carl Witthoft

External


Since: Mar 22, 2004
Posts: 528



(Msg. 2) Posted: Wed Oct 17, 2007 5:12 pm
Post subject: Re: importing space and/or comma delimited file [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

In article <1192632944.024461.99370.TakeThisOut@v23g2000prn.googlegroups.com>,
Noah Garrett Wallach <djbots.TakeThisOut@gmail.com> wrote:

> How might I import a space delimited file into excel?
> How might I import a comma delimited file into excel?

Just do it :-).

The trick is: Open Excel, then select File:Open and select the file
from the usual dialog box.

Excel will then start up a series of dialog boxes in which you specify
the input data are delimited, click on the delimiters (comma, tab,
space, etc), and off you go.

Note that in most configurations if you drag&drop the file onto Excel it
isn't smart enough to bring up this Import dialog.

--
Team EM to the rescue! mailto:carl@Team-EM.com http://www.team-em.com

 >> Stay informed about: importing space and/or comma delimited file 
Back to top
Login to vote
Display posts from previous:   
   Macintosh computer (Home) -> Excel All times are: Pacific Time (US & Canada) (change)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]