Inserting Dot Leaders in tables?

Hey @testgcd

About the TAB thing:
I may explain this here… Not same topic but in general, same struggle…
You will need coffee and cigarettes to read it

About Dot leader:
You can add dot leaders in a spreadsheet, but it’s not as straightforward as in Documents. Here’s how you can fake it like a pro:

Method 1: Manually with REPT() Formula

Use the REPT function to repeat dots:

=A1 & REPT(“.”, 50 - LEN(A1)) & B1

This takes the text in A1, adds dots until the total length reaches 50, then appends B1. Adjust 50 as needed.

Method 3: Dot Leader in a Separate Column

If you want full control:

  1. Put your left text in Column A.
  2. Put your right text in Column C.
  3. In Column B, fill it with dots ("..................") and adjust width.

And you are right, there is no method 2… :sweat_smile: but here a a sneaky way to fake dot leaders:

=A1 & " ⋯⋯⋯⋯⋯⋯ " & B1

(Adjust the number of dots as needed.)

  • Select the column where you want the dots.
  • Change the font to Courier New or another monospace font.
  • Type dots manually to create an even line between text and numbers.