Forum Discussion

Ntnk1999's avatar
Ntnk1999
Copper Contributor
Jun 29, 2022

How to Masking the Name

    Please help me. 
excel
  • Ntnk1999's avatar
    Ntnk1999
    Copper Contributor
    Jun 29, 2022

    Riny_van_Eekelen

    Thank you for your response.

    Alex Richards*****ards*********ards**** ****ards
    Alexis Rose*****rose*******rose****** rose
    Samantha James*****ames**********ames******** *ames
    Guiseppa De Santosh   

     

    ******** ** ***tosh
    i want this time of format.

    please help me with the last entry 

    • Riny_van_Eekelen's avatar
      Riny_van_Eekelen
      Platinum Contributor
      Jun 30, 2022

      Ntnk1999Probably a terrible formula if you don't have MS365 or Excel 2021. But if you are on either of these or Excel on-line, try this one:

      =TEXTJOIN("",,IF(MID(A1,SEQUENCE(LEN(A1)-4),1)=" ", " ","*"))&LOWER(RIGHT(A1,4))