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:
- Put your left text in Column A.
- Put your right text in Column C.
- In Column B, fill it with dots (
".................."
) and adjust width.
And you are right, there is no method 2… 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.