R
Renee R.
For example:
brian.........
angela......
bob..........
brian.........
angela......
bob..........
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
David Billigmeier
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)))
formula so enter it with Ctrl+Shift+Enter) and drag down:
=CONCATENATE(A1,REPT(".",MAX(LEN($A$1:$A$1000))-LEN(A1)))
E
Earl Kiosterud
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.
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.
R
Renee R.
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.
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.
D
Dave Peterson
Kind of like leaders in table of contents?
You could apply a custom format
format|Cells|number tab|Custom category:
@*.
You could apply a custom format
format|Cells|number tab|Custom category:
@*.
R
Renee R.
Thank you VERY much! That worked perfectly! Renee