Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 2
Default I have a name and then number and want to fill space in with dots


--
marianne dagher
  #2   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 35,218
Default 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
  #3   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 2
Default 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

  #4   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 22,906
Default 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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How can I automatically fill the remainder of a cell with dots (.. Tom Excel Discussion (Misc queries) 2 April 4th 23 10:35 AM
worksheet doesn't fill entire space mayura1 Excel Discussion (Misc queries) 4 October 17th 08 11:07 PM
fill (color) space between plots Kurt[_3_] Charts and Charting in Excel 2 February 20th 08 11:18 AM
Leading dots...trailing dots Josh O. Excel Discussion (Misc queries) 2 January 31st 08 07:22 PM
Excel - fill white space in cells Juliette UK/NZ Excel Discussion (Misc queries) 1 November 9th 05 03:04 PM


All times are GMT +1. The time now is 06:37 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"