Tip 268 – Quickly Split up text

If you have a cell with a person’s name and surname and would like to separate the name and surname so they show in separate cells, select the column that contains the names, click the Data tab and select “Text to Columns”. Choose the delimited option and click Next. Usually the name and surname are separated by a space or a comma, select the correct option and then click Finish.
This can be used with any type of text, such as product codes, phone numbers, etc.