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

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!

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


"wstock3" wrote in message
...
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!

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.

Try this custom format:

;;;@*.
--

HTH,

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

"wstock3" wrote in message
...
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!

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

wstock3 wrote:
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
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

stock

Try this Custom format

"@*."


Gord Dibben Excel MVP

On Thu, 3 Feb 2005 11:59:09 -0800, "wstock3"
wrote:

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!

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. :)
--
Dana DeLouis
Win XP & Office 2003


"wstock3" wrote in message
...
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!