Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I add periods to complete a word in a cell?
For example:
brian......... angela...... bob.......... |
#2
|
|||
|
|||
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.......... |
#3
|
|||
|
|||
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.......... |
#4
|
|||
|
|||
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.......... |
#5
|
|||
|
|||
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 |
#6
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I use word wrap in a merged cell in excel 2000? | Excel Discussion (Misc queries) | |||
searching a cell for a contained text word | Charts and Charting in Excel | |||
how do I make a word typed in a cell go to a specific cell in anot | Excel Discussion (Misc queries) | |||
How do I imbed a Word document into an Excel cell? | Excel Discussion (Misc queries) | |||
GET.CELL | Excel Worksheet Functions |