=TEXT fuction
 

C5 has a text format and contains, for example, "04-15-2010" or
"12-02-2002" or is empty.

How do I write a =TEXT function where "value" refers to C5 and "format-
text" returns the contents of C5 with 10-characters (for example:
"04-15-2010" or "12-02-2002" or " ")?

=TEXT fuction
 

"gary c" wrote:
How do I write a =TEXT function where "value" refers to
C5 and "format-text" returns the contents of C5 with
10-characters (for example:
"04-15-2010" or "12-02-2002" or " ")?

=LEFT(C5&REPT(" ",10),10)

You can replace REPT(" ",10) with a string that contains spaces. I used
REPT for clarity and flexibility.

=TEXT fuction
 

On Dec 24, 9:21*am, "joeu2004" wrote:
"gary c" wrote:
How do I write a =TEXT function where "value" refers to
C5 and "format-text" returns the contents of C5 with
10-characters (for example:
"04-15-2010" or "12-02-2002" or " * * * * *")?

=LEFT(C5&REPT(" ",10),10)

You can replace REPT(" ",10) with a string that contains spaces. *I used
REPT for clarity and flexibility.

Thank you, very much.

Now I'll post a new more-complidated question.