Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1080
  • Last Modified:

Great Plains, Exporting to Excel

Hi,
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.

Thanks
0
Cassavatech
Asked:
Cassavatech
1 Solution
 
patrickabCommented:
Cassavatech,
Perhaps it might be easiest to edit the data with a macro - so removing the CR character.
Patrick
0
 
mikeopoloCommented:
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.

Regards
Mike
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now