![[엑셀]아이피 주소 일부 숨김(별표) 치환](https://img1.daumcdn.net/thumb/R750x0/?scode=mtistory2&fname=https%3A%2F%2Fblog.kakaocdn.net%2Fdn%2FwdtWr%2FbtsJhDN4CeY%2FZT2nb6ls83rzqXr2dkynQK%2Fimg.jpg)
# 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))