Using Replace to remove unspecified amount of letters

New Contributor

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 contains the last name, the comma, and ONLY THE FIRST LETTER of the first name i.e. Smith, J    Walker, M

Thank you

2 Replies
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.
Related Conversations
A problem with the Zoom level of a Tab
Tavory in Discussions on
9 Replies
Tilde not working to replace asterisk?
dmharris in Excel on
3 Replies
Find and Replace with Growing Number
ryan_k in Word on
0 Replies