PC Magazine (opens in new tab): My favorite new feature, because it saves a tremendous amount of time-wasting effort, is called Flash Fill, and it’s one of many features where Excel acts as it it’s ...

Let’s say you have student information in a worksheet where students’ last names, first names, and ID numbers are in Column A. If you want their first name and last name to appear in Column B, you ...