Welcome to MacForumz.com!
FAQFAQ   SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log in/Register/PasswordLog in/Register/Password

importing space and comma delimited file

  
   Macintosh computer (Home) -> Excel RSS
Related Topics:
importing space and/or comma delimited file - How might I import a space delimited file into excel? How might I import a comma delimited file into excel?

Saving in comma delimited format - When I import a list of contacts in a comma delimited format that=20 works fine. Then I try to save it in a comma delimited format, I see = that=20 is in columns, which I think it should be. Then when I come=20 back and open the file again the..

Commas remain after saving as tab-delimited when importing.. - I can't seem to import my excel database without gaining commas. I have saved the worksheet as a tab delimited format and then imported them into Yet, even after going back in and removing all commas from the excel sheet and then..

Data being delimited when pasting - Hello, I have a user who is running into a problem when pasting copied from web pages. The is displayed on the web page in multiple columns (actually formatted into tables with multiple rows and colums, not just text

Opening/Importing a csv file in Excel v.X - Hi, I cant open a csv file in Excel. I have tried File Open, and Import The file is always dimmed. I also tried Get Info/Open with, and the Excel option is dimmed. I'm using Excel SR1 and OS X 10.2.8 any ideas anyone? Vicktor
Next:  Excel: Graphics package, bar chart with several data series, orga..  
Author Message
Noah Garrett Wallach

External


Since: Oct 17, 2007
Posts: 1



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

1) what are the steps to import space delimited file?
2) what are the steps to import comma delimited file?

Cheers,

Noah

 >> Stay informed about: importing space and comma delimited file 
Back to top
Login to vote
JE McGimpsey

External


Since: Mar 07, 2004
Posts: 3826



(Msg. 2) Posted: Wed Oct 17, 2007 2:18 pm
Post subject: Re: importing space and comma delimited file [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
In article <1192638934.132963.88690 DeleteThis @i38g2000prf.googlegroups.com>,
Noah Garrett Wallach <djbots DeleteThis @gmail.com> wrote:

> 1) what are the steps to import space delimited file?
> 2) what are the steps to import comma delimited file?

One way:

Unlike WinXL (which will auto import files with the.csv extension), you
can use File/Open, then follow the Text Import Wizard (choose Delimited,
click Next, check Space or Comma, then click Finish

To import into a current workbook, choose Data/Get External Data/Import
Text file... and follow the same steps.

 >> Stay informed about: importing space and comma delimited file 
Back to top
Login to vote
TMc

External


Since: Mar 25, 2008
Posts: 1



(Msg. 3) Posted: Tue Mar 25, 2008 9:14 am
Post subject: Re: importing space and comma delimited file [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
USING A IMAC, I HAVE A WEBSITE, NEED TO IMPORT CUSTOMER INFO IN MYOB FIRST EDGE ACCOUNTING SOFTWARE.
IT WAS EMAILED TO ME USING EXCEL AND FORMAT COMMA-SEPERATED, WOULD NOT IMPORT GAVE AN ERROR MESSAGE

"Error -4: First digit of Account Number must be 1,2,3,4,5, or 6."
Error -185: Account Type is too long or contains invalid characters.

I CONTACT MANUFACTURER OF MYOB AND THEY SAID THAT IT NEEDS TO BE DOUBLE CARRIED TO BE IMPORTED WHAT DOES THIS MEAN

THANK YOU TO ANY AND ALL THAT CAN HELP ME
 >> Stay informed about: importing space and comma delimited file 
Back to top
Login to vote
SUPPORT_OUR_TROOPS!

External


Since: Mar 25, 2008
Posts: 2



(Msg. 4) Posted: Tue Mar 25, 2008 9:42 am
Post subject: Re: importing space and comma delimited file [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
IS THIS FOR A MAC COMPUTER I'M NOT SURE WHAT YOUR ANSWER IS
 >> Stay informed about: importing space and comma delimited file 
Back to top
Login to vote
SUPPORT_OUR_TROOPS!

External


Since: Mar 25, 2008
Posts: 2



(Msg. 5) Posted: Tue Mar 25, 2008 9:44 am
Post subject: Re: importing space and comma delimited file [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
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 ]