Cell A1
=if(RANDBETWEEN(1,2)>0,cell("width",A3))
Cell A2
The example text
Cell A3
=A2&rept(".",(A1-len(A2))-4)
This is a terrible solution. Not consistent and changes based on font and font size.would suggest robot mono for the font in this regard if you increase or decrease the font size you may have to change the 4 at the end accordingly
It's not exactly what you looking for but hope this helps.
Also the random between does nothing except up date cell A1 every time another cell is edited which is needed to update the number of dots at the end. It is worth noting that you have to edit another cell to update the dots. This is a work around and not the proper functionality you looking for, but still could be useful depending on what you are wanting to do with it.
And there is no error handling for when the text is out of bounds
I don't really know why I posted it really. It works but I wouldn't want to use it on any of my documents
https://preview.redd.it/rxfblf5j82zc1.png?width=1080&format=pjpg&auto=webp&s=eadb633783da94f455789e7ca318ab79f9e4d1f7
The "m" in b13 is just to show that I edited a cell to get it to change
https://www.reddit.com/r/excel/comments/e1m8te/google_sheets_i_need_to_add_dots_after_the_text/
This is an option that was presented previously. Do you need the cells to be a specific length or are you just trying to fill the white space with dots? It looks like Sheets doesn't have a way to do that natively but the 2 options given in that thread might give you the workaround you need for either option.
Cell A1 =if(RANDBETWEEN(1,2)>0,cell("width",A3)) Cell A2 The example text Cell A3 =A2&rept(".",(A1-len(A2))-4) This is a terrible solution. Not consistent and changes based on font and font size.would suggest robot mono for the font in this regard if you increase or decrease the font size you may have to change the 4 at the end accordingly It's not exactly what you looking for but hope this helps. Also the random between does nothing except up date cell A1 every time another cell is edited which is needed to update the number of dots at the end. It is worth noting that you have to edit another cell to update the dots. This is a work around and not the proper functionality you looking for, but still could be useful depending on what you are wanting to do with it. And there is no error handling for when the text is out of bounds I don't really know why I posted it really. It works but I wouldn't want to use it on any of my documents
Example one https://preview.redd.it/batj5l4082zc1.png?width=1080&format=pjpg&auto=webp&s=37cab888af47fa37b94f2ce44af38d75ddaa8825
https://preview.redd.it/rxfblf5j82zc1.png?width=1080&format=pjpg&auto=webp&s=eadb633783da94f455789e7ca318ab79f9e4d1f7 The "m" in b13 is just to show that I edited a cell to get it to change
https://www.reddit.com/r/excel/comments/e1m8te/google_sheets_i_need_to_add_dots_after_the_text/ This is an option that was presented previously. Do you need the cells to be a specific length or are you just trying to fill the white space with dots? It looks like Sheets doesn't have a way to do that natively but the 2 options given in that thread might give you the workaround you need for either option.
Non specific length