We finally got SMART FILL in GOOGLE SHEETS and it was worth the wait! It's amazing!
I waited a long time for Google Sheets to get Smart Fill and
it was worth the wait. It's the equivalent of Flash Fill in Excel and they are
both amazing! Smart Fill makes it so easy to separate full names into different
columns for first and last name. You can also change a first and last name to
"last name, first name" and vice versa. This comes in handy so many
times when you download a report and the names are not listed in a way that you
can sort them alphabetically. Now you can just use Smart Fill to change the way
the names are listed!