Hi, I am working on a shipping company and want to make our work a bit easier. Lately, we are dealing with manually entering data of customer on our system. Unfortunately, it takes much time than the normal processing.
Question: Is there a way or formula so that I can consolidate below details automatically using excel?
As shown below, it is much easier if we can have a file that can easily fetch data by pasting raw shipping instruction from customer.
Format of their SI always have indention on party details and always have unnecessary words/characters on their goods description.
What function I can use to automatically remove indention whenever I'm pasting data? Also, for their description, we don't need the word "GOODS DESC" and the ">".
Thank you very much in advance!
SHIPPER
COMPANY NAME
ADDRESS 1
ADDRESS 2
ADDRESS 3
CONTACT
CNEE
COMPANY NAME
ADDRESS 1
ADDRESS 2
ADDRESS 3
CONTACT
---STUFFING DETAILS ---
GOODS DESC
>PACKAGE TYPE
GOODS DESC
>LADIES DRESS
GOODS DESC
>BOYS SHORTS
Question: Is there a way or formula so that I can consolidate below details automatically using excel?
As shown below, it is much easier if we can have a file that can easily fetch data by pasting raw shipping instruction from customer.
Format of their SI always have indention on party details and always have unnecessary words/characters on their goods description.
What function I can use to automatically remove indention whenever I'm pasting data? Also, for their description, we don't need the word "GOODS DESC" and the ">".
Thank you very much in advance!
SHIPPER
COMPANY NAME
ADDRESS 1
ADDRESS 2
ADDRESS 3
CONTACT
CNEE
COMPANY NAME
ADDRESS 1
ADDRESS 2
ADDRESS 3
CONTACT
---STUFFING DETAILS ---
GOODS DESC
>PACKAGE TYPE
GOODS DESC
>LADIES DRESS
GOODS DESC
>BOYS SHORTS