How do I insert a leader from the end of text to the end of a cel.

[Guest]

If you look at financial data you will see that there is often a leader
(dotted underline), between a field name or catagory and the data that it is
referencing. An example:

Region Revenue
Boston..........$100,000.00

I am trying to determine how to do this in excel. I do not want to
underline the entire cell. I want the leader to start at the end of the word
an go to the end of the cell.

Any help is appreciated - Thanks!

 

[Arvi Laanemets]

Hi

What do you mean with "the end of cell" in Excel?
From Help - Worksheet and workbook specifications:
Column width = 255 characters
Length of cell contents (text) = 32767 characters.

The visible cell width isn't in any way bound to cell contents (but the cell
width can influence the way the cell contents are displayed)


Arvi Laanemets

 

[Guest]

make a dummy column with the city names, next to it use the formila:

=concatenate(A1,"................................")

this will put the dots in, but if there is nothing in the next cell to the
right to cut things off, the thing mentioned above will happen, you will see
all the dots.

 

[RagDyer]

Try this custom format:

;;;@*.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

If you look at financial data you will see that there is often a leader
(dotted underline), between a field name or catagory and the data that it is
referencing. An example:

Region Revenue
Boston..........$100,000.00

I am trying to determine how to do this in excel. I do not want to
underline the entire cell. I want the leader to start at the end of the
word
an go to the end of the cell.

Any help is appreciated - Thanks!

 

[Debra Dalgleish]

Select the cells in which you want the dots
Choose Format>Cells
On the Number tab, choose Custom
In the text box, type: @*.
Click OK

 

[Gord Dibben]

stock

Try this Custom format

"@*."


Gord Dibben Excel MVP

 

[Dana DeLouis]

Hello. Here are two ideas you can experiment with. Suppose that Boston is
in A1, and 100000 is in cell B1.
For A1, make a custom format as "@ *."

The @ represents the text in the cell (Boston), and the "*" repeats the next
character (period) the width of the cell.

Or, perhaps leave Boston alone, and customize B1 with "*. $#,###.00"
This would put leading periods in front of the number.

HTH. :>)