Leading dots...trailing dots

[Josh O.]

I know its possible to have a symbol/text repeat before or after text in a
field.
Using, for example, *- custom number format.

Is it possible to have a repeating character before and after text?
Centered between the leading and trailing characters.
Example:
|----- Text -----|

Thanks for any help.

 

[smw226 via OfficeKB.com]

Hi Josh,

The custom format: -------@-------- should do what you are after if the
number lines before and after is fixed.

If you want the enire string to be a fixed length something like REPT("-",(10-
(LEN(B1))))&B1&REPT("-",(10-(LEN(B1)))) where 10 is the fixed with should do

HTH

Simon

========================================================================

I know its possible to have a symbol/text repeat before or after text in a
field.
Using, for example, *- custom number format.

Is it possible to have a repeating character before and after text?
Centered between the leading and trailing characters.
Example:
|----- Text -----|

Thanks for any help.

--
--------------------
Simon - UK

Email at simon22mports [ a t ] hot mail [ d ot ]com

Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.aspx/ms-excel/200801/1

 

[Josh O.]

I am familiar with the format you referenced. And thanks for the formula, I
would had thought of trying it that way (although I would have to rethink how
the user enters data in the field in order to use it this way...hummm. Have
to think on it a bit).

Unfortunately, the cell(s) are not a fixed width. That kindof throws a
monkey wrench into it.

Hi Josh,

The custom format: -------@-------- should do what you are after if the
number lines before and after is fixed.

If you want the enire string to be a fixed length something like REPT("-",(10-
(LEN(B1))))&B1&REPT("-",(10-(LEN(B1)))) where 10 is the fixed with should do

HTH

Simon

========================================================================

I know its possible to have a symbol/text repeat before or after text in a
field.
Using, for example, *- custom number format.

Is it possible to have a repeating character before and after text?
Centered between the leading and trailing characters.
Example:
|----- Text -----|

Thanks for any help.

--
--------------------
Simon - UK

Email at simon22mports [ a t ] hot mail [ d ot ]com

Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.aspx/ms-excel/200801/1