Share via

How to separate names in Excel

Anonymous
2023-02-20T04:39:32+00:00

So, I have a column of data(Full Name) but they have been listed interchangeably(first and last and then last and first name). What I want to happen is separate the Full Name(but were listed interchangeably) into two separate columns which are th First Name and Last Name columns.

How do I fix it? Please see attached photo for the data that I am referring to.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2023-02-20T05:30:23+00:00

    Hello Xodjbgxo,

    Thank you for reaching out to the Microsoft Community.

    Below I have attached a link from timeatlas.com to guide you on how to Separate Names in Excel:

    https://www.timeatlas.com/split-names-excel/

    Let me know if you need more help.

    Give back to the community, help the next person who has this problem by indicating if this answer solved your problem. Click Yes or No below.

    Kind regards Eunice

    1 person found this answer helpful.
    0 comments