Split cell

I have one row in my spreadsheet for First and Surname of my customers. How can I split this row into 2 seperate rows – First Name and Surname. Obviously taking into acount that there are cells that will have only one name (so lets assume it will be First name) and some have no names at all.

By: Shlomo

Leave a Reply

Your email address will not be published. Required fields are marked *