Formating one cell in more cells (Excel)



Get your material ready

Ask for the contact details you need from BO

Copy to Excel 

Copy the information you receive in a new Excel file and save the document. (The cells are in one row)

Format the cells  

Open a new Excel file Click on: Data Click on: From Text Select the right document (the one you saved)(make sure you save it by clicking with you right mouse button on the CSV file in BO, as a link) Click on: next Select the delimiters(eg. Semicolon) Select: Next, Finish Select the row you want to format into cells

Click: OK