I have a name and then number and want to fill space in with dots
 

--
marianne dagher

I have a name and then number and want to fill space in with dots
 

If you're putting this info into a single cell, then stop!

Put each value in separate cells--in fact, I'd consider putting first name in a
cell, last name in a different cell, middle initial(???), salutation(???), and
number in different cells.

mariane wrote:

--
marianne dagher

--

Dave Peterson

I have a name and then number and want to fill space in with d
 

Thanks Dave I stayed in excel and did that drew and copied a line of dots and
pasted them into the cells. it printed quite well. My challenwas to connect
text by dots
--
marianne dagher


"Dave Peterson" wrote:

If you're putting this info into a single cell, then stop!

Put each value in separate cells--in fact, I'd consider putting first name in a
cell, last name in a different cell, middle initial(???), salutation(???), and
number in different cells.

mariane wrote:

--
marianne dagher

--

Dave Peterson

I have a name and then number and want to fill space in with d
 

Mariane

There is an easier way to set leaders in a cell.

FormatCellsCustom @*.

That is @*dot


Gord Dibben MS Excel MVP

On Wed, 3 Dec 2008 10:05:01 -0800, mariane
wrote:

Thanks Dave I stayed in excel and did that drew and copied a line of dots and
pasted them into the cells. it printed quite well. My challenwas to connect
text by dots