Jan 09
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′
Firstname:
=LEFT(B2,(SEARCH(" ",B2)-1))
Lastname:
=MID(B2,(SEARCH(" ",B2)+1),20)
(Ads provided by Google Adsense.)
