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
Separation of the text
- Oliver Wilkins
- Closed
-
-
-
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.
-
That's what I wanted to hear, thank you!
-
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.
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!