Forum Discussion
Family Lieberman
Oct 25, 2017Copper Contributor
Using Replace to remove unspecified amount of letters
I am a teacher. I have an excel file of all students written as Lastname, Firstname for example Smith, John or Walker, Martin. How can I use the replace command to change each cell so that it only...
SergeiBaklan
Oct 25, 2017Diamond Contributor
Hi,
Flash Fill works http://www.dummies.com/software/microsoft-office/excel/how-to-use-flash-fill-in-excel-2013/