Forum Discussion

FatManFluff's avatar
FatManFluff
Brass Contributor
Aug 23, 2024
Solved

Adding a , after a group of text

Good morning, I was looking to add a ,(coma) and a space after every 4 characters. For example, qwerasdfzxcv ------> qwer, asdf, zxcv not always will it always be 12 characters but will always be ...
  • HansVogelaar's avatar
    Aug 23, 2024

    FatManFluff 

     

    =TEXTJOIN(", ", TRUE, MID(A1, SEQUENCE(ROUNDUP(LEN(A1)/4, 0), , , 4), 4))

Resources