General discussion

Locked

Excel

By ccthompson ·
I have an export of quickbooks to excel. I am trying to get all the customers info.

SO i exported it, only to find that it put the company name, address, state, zip all in one column. Is there a way to spilt this up?

I tried the data menu, text to columns tool. But I cant do it because it splits it up too far. Any other suggestions?

This conversation is currently closed to new comments.

8 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

by RDK55 In reply to Excel

Not sure how Quickbooks exports info. but is it possible to export (or save) the info. as a .csv file? Excel might have a little better time importing it that way.

Collapse -

by ccthompson In reply to

Thanks for the post

Collapse -

by ccthompson In reply to Excel

It imports into excel ok, it gets them into columns and everything: (example)

Bill To | Phone Number | Fax | Terms

The only one that is all screwed up it that Bill To column. Cause it has the company name, address, state, and zip all in one cloumn.

Any help is much appreciated...

Collapse -

by RDK55 In reply to Excel

OK. While I'm not going to be able to claim credit for coming up with it on my own <g>, this looks like the solution you're looking for...

http://www.mrexcel.com/board2/viewtopic.php?t=211380

Collapse -

by ccthompson In reply to

Thanks for the post

Collapse -

by Tig2 In reply to Excel

You should be able to specify the export characteristics. Export as a .csv. Save your export file. Go to Excel and set it to look for csv files. Open the file- you get the import wiz. Define the data sset as csv and check the columns in the preview pane. Finish the wiz, have fun with your data.

Yes, I know- not intuitive.

Collapse -

by ccthompson In reply to

Thanks for the post

Collapse -

by ccthompson In reply to Excel

This question was closed by the author

Back to Software Forum
8 total posts (Page 1 of 1)  

Related Discussions

Related Forums