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.

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

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

Josh O. wrote:
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.a...excel/200801/1

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.

"smw226 via OfficeKB.com" wrote:

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

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

Josh O. wrote:
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.a...excel/200801/1