This may be impossible, but I thought I would ask...
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!
|