Today I had a list of full names (eg “Ed Smith”) in a Numbers spreadsheet. I wanted to separate it into first and last name to be able to sort if alphabetically. It was harder than it should be – in my opinion Apple should have a firstname and lastname function! But they don’t. So here’s how to get first name and last name.
After you’ve done this if you want to delete the original full names you’ll need to ‘copy’ then ‘paste values’ over the formula.
The Original full name is in the cell ‘B2’
Enjoyed this article?
You can help me by clicking on any other article. Google have started penalising this site because it is so good! People read an article, get the answer they want, and leave. I think this is a great thing, but Google have a different view. They call it a 'bounce' and have started penalising sites that people only visit one page on. They perceive it as 'you didn't like what you saw, so you left' when in fact it could have been 'you got what you needed so you left.' So please, if this article was helpful, just click back to the front page or to any other article on this site. This says to Google you like this site. Thanks!
Leave a Reply