Custom format

[Imy Jean]

I am putting together a directory for our church in Excel and wanting to know a simple way for placing ....(dots) from the end of entered address up to the next field which is the phone number. I need to do this for about 5,000 names.

[oldchippy]

Hi Imy Jean,

Welcome to the forum, please have a read here, it would help if you changed the title of your question

http://www.excelforum.com/showthread.php?t=617557

But here's the answer to your question, if your names are in column A, then format the cells to Custom format @*.
This will fill the cell to the right of the text with dots, then in column B put the telephone numbers.

If you want dots before your telephone number, then custom format those cells to *.@ but you will need to put a dot before each telephone number.

An easy way to do that, if you already have your numbers in a column B is to enter this formula in C1

="."&B1 and autofill down by dragging the fill handle.