Google Sheets is a good alternative to paid Microsoft Excel. It offers plenty of features that make users’ everyday tasks pretty easy. Although it is good with calculating formulas it still not good with text and text-related data.
Now Google is going to change that. The new update for Google Sheets will introduce a new feature called “Smart Fill.” The feature is similar to Gmail’s Smart Compose that automatically predicts words and sentences.
TechCrunch quoted Google, “Say you have a column of full names, but you want to split it into two columns (first and last name, for example). As you start typing first names into a column, Sheets will automatically detect the pattern, generate the corresponding formula, and then autocomplete the rest of the column for you.”
There is one more feature that will be available later this year for Google Sheets. It will be called Smart Cleanup and it will automatically identify duplicate rows and clean up from your data. It will also fix your formatting issues.