Separation of the text

Oliver Wilkins · Oct 5th 2021

There is a part of my document attached. I have to separate the names and surnames of the people in column A so that names will be in column A and the surnames in column B. How can this task be completed?Book1.xlsx

**royUK** · Oct 5th 2021

You cannot keep the first name in A with formulas. You can do this with Text To Columns from the Data Tab.

This explains how to it.

Separate Names

Oliver Wilkins · Oct 5th 2021

That's what I wanted to hear, thank you!

**royUK** · Oct 6th 2021

Pleased to help.

Post back if you need further help.

Visit my web site, http://www.excel-it.com, for more examples and some helpful articles.

Separation of the text

Participate now!

Share