I need to conceal information on a spreadsheet... text of first name and last name (separate columns) leaving just the first letter of each in the cell. I know you can remove a set number of letters using (I believe) the LEN command but there many different names in each column. I tried to use REPLACE, trying "A*" to be replaced with "A" but it changed all of the names to "A".



Any ideas or workarounds that might work?

E.G.
A B A B
Change: Smith John to S J

Thanks!