Great Plains, Exporting to Excel

Posted on 2008-11-15
Last Modified: 2013-12-11
I'd like to know how I can export a field from Great Plains into Excel without getting the return character.
Each time we select a field in GP, copy and paste into Excel, we get the value + the return character.

Question by:Cassavatech
    LVL 45

    Accepted Solution

    Perhaps it might be easiest to edit the data with a macro - so removing the CR character.
    LVL 10

    Expert Comment

    Can you explain a bit more about what you are doing? If this is something you are doing over and over, there are other ways to transfer data to Excel from GP, eg GP's own extracton s/w Smartlists.


    Featured Post

    How to improve team productivity

    Quip adds documents, spreadsheets, and tasklists to your Slack experience
    - Elevate ideas to Quip docs
    - Share Quip docs in Slack
    - Get notified of changes to your docs
    - Available on iOS/Android/Desktop/Web
    - Online/Offline

    Join & Write a Comment

    Suggested Solutions

    If you need to import sales transactions from another system into Microsoft Dynamics GP as Sales Order Invoices, you may need to store some additional data related to the customer, the transaction, or the line items.  Even if your company is manuall…
    As an accountant it is essential that I am able to provide accurate and timely information to management and staff.  One of the challenges that I have faced is the need to report on a time period, whether it be a month, quarter, or year, and wanting…
    The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
    The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…

    754 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now