![[엑셀]아이피 주소 일부 숨김(별표) 치환](https://img1.daumcdn.net/thumb/R750x0/?scode=mtistory2&fname=https%3A%2F%2Fblog.kakaocdn.net%2Fdna%2FwdtWr%2FbtsJhDN4CeY%2FAAAAAAAAAAAAAAAAAAAAAEuzjum6N2xx2rAoBy4xbZVCMv3JSwDXIfDHWIYL46KK%2Fimg.jpg%3Fcredential%3DyqXZFxpELC7KVnFOS48ylbz2pIh7yKj8%26expires%3D1753973999%26allow_ip%3D%26allow_referer%3D%26signature%3Dulhm4estUujwB%252F8pN4aPGyDDG44%253D)
# Etc/EXCEL2024. 8. 28. 10:07[엑셀]아이피 주소 일부 숨김(별표) 치환
=TEXTJOIN(".",TRUE,INDEX(TEXTSPLIT(B2,"."),1),INDEX(TEXTSPLIT(B2,"."),2),"*",INDEX(TEXTSPLIT(B2,"."),4))
=TEXTJOIN(".",TRUE,INDEX(TEXTSPLIT(B2,"."),1),INDEX(TEXTSPLIT(B2,"."),2),"*",INDEX(TEXTSPLIT(B2,"."),4))