CINC Systems interview question

How would you separate or combine certain data within excel fields