#1
|
|||
|
|||
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! |
#2
|
|||
|
|||
Concealed Data
Hello,
Maybe this will help. Please see attachment. Regards, Zade :-) |
#3
|
|||
|
|||
YOU NAILED IT!!!!! (btw, it was commas on my machine). Thank you very much for your expertise!!
|
|