Numbers: Change the order of text in a cell/swap lastname firstname into firstname lastname

I copied a list of names from a site (it is allowed) and the full names are in one column with the last name first and the first name last (Brown, Fred). I need to reformat it into Fred Brown. I have a lot of these to do so I need some efficiency. I can't seem to find any function that will help me out here.

MacBook Pro 15″, macOS 11.6

Posted on Jun 19, 2023 11:34 AM

Reply
2 replies

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

Numbers: Change the order of text in a cell/swap lastname firstname into firstname lastname

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.