Divide name and surname on Excel or Drive

Judit -

In this tutorial you will see how simple it is to divide the data of one column into different columns to be able to import students directly from Excel to Additio.

 

First, we open the student list document in Excel and create one more column next to the column that contains the name and surname so that the surnames are imported:

excel_1.JPG

 

Select the column you want to divide and press the option Data> Divide text into columns

 

excel_2.JPG

 

Press the option and the split option will appear at the bottom of the list of students.

At this time you can select which type of splitting do you want to use, we will use the Space, but you must choose the most suitable for your case.

excel_3.JPG

 

Once you select it, the name and surname will be divided and you will be able to import them into the application with the option to Import students from Excel. 

excel_4.JPG

NOTE: The tutorial shows how to do it from Google Drive, but from Excel it is exactly the same: Select the column> Click on Data> In the Data tools section> Click on Text in columns

 

¿Tiene más preguntas? Enviar una solicitud

0 Comentarios

El artículo está cerrado para comentarios.
Tecnología de Zendesk