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
Ive been able to just add 1 , after qwer, but no multple using
=replace(a1,5,0,”, “)
im sure I can probably tie in the same formula Mutiple times but have no clue how
Good morning, I was looking to add a ,(coma) and a space after every 4 characters.For example,qwerasdfzxcv ——> qwer, asdf, zxcv Ive been able to just add 1 , after qwer, but no multple using =replace(a1,5,0,”, “) im sure I can probably tie in the same formula Mutiple times but have no clue how Read More
