I export all of my orders to a shipping program but the first and last name always end up on separate lines. Is there a way to tweak the export fields to put the in the same csv column?
After you export. Open in Excel and create a new column and concatenate the first and last together.
For example: A1=First B1=Last C1=Full Name
“C” formula would be: =A2&" "&B2
Save the csv and load into shipping.
Hi. Thanks for the tip, but I’m looking to directly export it without having to manually change it each time. I’m trying to train my husband to take over the order processing and need it to be a complete PhD system (Push Here Dummy). He can’t find google on his own…
[quote name=‘topher’]After you export. Open in Excel and create a new column and concatenate the first and last together.
For example: A1=First B1=Last C1=Full Name
“C” formula would be: =A2&" "&B2
Save the csv and load into shipping.[/QUOTE]