excel text import wizard enter key delimiter

Do not add any rows to the custom label file however, it is only necessary to import rows that contain a custom label update.This may cause the format to be rejected by the system when you attempt to import the file. The slash '/' character indicates the description above it is repeated.

Do not update any cell that displays a slash '/' character.

On Step 3 of 3 of the Text Import Wizard highlight one column at a time in the Data Preview section and click the Text radio button until each column says Text in the header row.ġ6. (The Pipe '|' character is on the key above the Enter Key where the backslash is located.)ġ4. On Step 2 of 3 of the Text Import Wizard enter the Pipe '|' character in the box following the word Other. On Step 1 of 3 of the Text Import Wizard make sure Delimited is checked.ġ2. Note: This will launch the Text Import Wizard.ġ0. Locate the Custom Label file you saved to your computer, highlight it and click Open. Change the Excel Files of Type dropdown to Text Files.ĩ. Click the link under the File Name column to save the file to your computer.Ĩ.

Retrieve the Custom Label Download file from BusinessDirect eBill by choosing View Bill>Retrieve Download.ĥ. A confirmation message is displayed, with a message informing you that your request has been submitted successfully and that an email message will be sent to you when the bill is available.Ĥ. Navigate to the Custom Labels screen by opening the Functions menu and then selecting the relevant option under the Custom Labels heading.Ģ. The information below outlines the steps necessary to export a custom label file, modify the file format and label contents, and then import the file to BusinessDirect eBill.ġ. Exporting and Importing Custom Label Files

Excel text import wizard enter key delimiter