How do I add periods to complete a word in a cell?
 

For example:

brian.........
angela......
bob..........

Assume your names are in the range A1:A1000, enter this formula in B1 (array
formula so enter it with Ctrl+Shift+Enter) and drag down:

=CONCATENATE(A1,REPT(".",MAX(LEN($A$1:$A$1000))-LEN(A1)))
--
Regards,
Dave


"Renee R." wrote:

For example:

brian.........
angela......
bob..........

Renee,

I think you're asking how to get Excel to complete a cell with known values
(like Brian's full name when you've only started to type it). But I'm not
at all sure. If so, post back. There's a way.
--
Earl Kiosterud
www.smokeylake.

"Renee R." wrote in message
...
For example:

brian.........
angela......
bob..........

No... not exactly. I want the cell to be completed with all periods after
each name. I have one name per cell from A7 down to A50... and after each
name I want to see periods up to the end of the cell.

"Earl Kiosterud" wrote:

Renee,

I think you're asking how to get Excel to complete a cell with known values
(like Brian's full name when you've only started to type it). But I'm not
at all sure. If so, post back. There's a way.
--
Earl Kiosterud
www.smokeylake.

"Renee R." wrote in message
...
For example:

brian.........
angela......
bob..........

Kind of like leaders in table of contents?

You could apply a custom format
format|Cells|number tab|Custom category:

@*.



Renee R. wrote:

No... not exactly. I want the cell to be completed with all periods after
each name. I have one name per cell from A7 down to A50... and after each
name I want to see periods up to the end of the cell.

"Earl Kiosterud" wrote:

Renee,

I think you're asking how to get Excel to complete a cell with known values
(like Brian's full name when you've only started to type it). But I'm not
at all sure. If so, post back. There's a way.
--
Earl Kiosterud
www.smokeylake.

"Renee R." wrote in message
...
For example:

brian.........
angela......
bob..........




--

Dave Peterson

Thank you VERY much! That worked perfectly! Renee

"Dave Peterson" wrote:

Kind of like leaders in table of contents?

You could apply a custom format
format|Cells|number tab|Custom category:

@*.



Renee R. wrote:

No... not exactly. I want the cell to be completed with all periods after
each name. I have one name per cell from A7 down to A50... and after each
name I want to see periods up to the end of the cell.

"Earl Kiosterud" wrote:

Renee,

I think you're asking how to get Excel to complete a cell with known values
(like Brian's full name when you've only started to type it). But I'm not
at all sure. If so, post back. There's a way.
--
Earl Kiosterud
www.smokeylake.

"Renee R." wrote in message
...
For example:

brian.........
angela......
bob..........




--

Dave Peterson