|
how to make ........ even after a title in a cell?
I am creating a table and want to put ................ to the end of the cell
and want it to be even in viewing and printing. i.e.: [see below...I copied from the cells] Task Hours Criteria Design Compliance¦¦¦¦¦¦¦¦¦¦¦¦¦ ¦¦¦.. VE Review¦¦¦¦¦¦¦¦¦¦¦¦¦¦ ¦¦¦¦¦¦¦¦¦¦ GMP/Bid Review¦¦¦¦¦¦¦¦¦¦¦¦¦¦ ¦¦¦¦¦¦¦. Contract Negotiations¦¦¦¦¦¦¦¦¦¦¦¦ ¦¦¦¦¦¦¦ Any help is greatly appreciated! |
how to make ........ even after a title in a cell?
Format cell, number tab, custom:
@*. This will to column width. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Penny_in_FL" wrote: I am creating a table and want to put ................ to the end of the cell and want it to be even in viewing and printing. i.e.: [see below...I copied from the cells] Task Hours Criteria Design Compliance¦¦¦¦¦¦¦¦¦¦¦¦¦ ¦¦¦.. VE Review¦¦¦¦¦¦¦¦¦¦¦¦¦¦ ¦¦¦¦¦¦¦¦¦¦ GMP/Bid Review¦¦¦¦¦¦¦¦¦¦¦¦¦¦ ¦¦¦¦¦¦¦. Contract Negotiations¦¦¦¦¦¦¦¦¦¦¦¦ ¦¦¦¦¦¦¦ Any help is greatly appreciated! |
how to make ........ even after a title in a cell?
Play with these:
="Apple"&REPT(".",100) ="Apple"&REPT(".",100-LEN("Apple")) best wishes -- Bernard Liengme MVP Excel http://people.stfx.ca/bliengme "Penny_in_FL" wrote in message ... I am creating a table and want to put ................ to the end of the cell and want it to be even in viewing and printing. i.e.: [see below...I copied from the cells] Task Hours Criteria Design Compliance¦¦¦¦¦¦¦¦¦¦¦¦¦ ¦¦¦.. VE Review¦¦¦¦¦¦¦¦¦¦¦¦¦¦ ¦¦¦¦¦¦¦¦¦¦ GMP/Bid Review¦¦¦¦¦¦¦¦¦¦¦¦¦¦ ¦¦¦¦¦¦¦. Contract Negotiations¦¦¦¦¦¦¦¦¦¦¦¦ ¦¦¦¦¦¦¦ Any help is greatly appreciated! |
how to make ........ even after a title in a cell?
If you would want to fill the cell with dots for *text only*,
allowing the regular entry of numbers, try this custom format: * General;* -General;* 0;@*. -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "Penny_in_FL" wrote in message ... I am creating a table and want to put ................ to the end of the cell and want it to be even in viewing and printing. i.e.: [see below...I copied from the cells] Task Hours Criteria Design Compliance.................. VE Review........................ GMP/Bid Review...................... Contract Negotiations................... Any help is greatly appreciated! |
| All times are GMT +1. The time now is 08:08 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com