Forum Discussion
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...
Thank you so much! Worked amazingly after I spent so much time trying to use the Replace command with * and ? that just didn't work. Thanks for taking the time to answer.