Excel Trick: Split Names & Sort by Last—In 30 Seconds
Автор: XL4MULA
Загружено: 2025-08-21
Просмотров: 281
Описание: Need to sort by last name in Excel? Split full names in seconds with Flash Fill (Ctrl+E). Type the first example, hit Ctrl+E to auto-fill First Name, repeat for Last Name, rename headers, press Ctrl+A to select the range, then Sort → My data has headers → Last Name. Clean up by deleting the helper columns. Fast, simple data cleaning for contact lists, rosters, and spreadsheets—no formulas required.
Повторяем попытку...
Доступные форматы для скачивания:
Скачать видео
-
Информация по загрузке: