=TEXT fuction

[gary c]

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 " ")?

 

[joeu2004]

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.

 

[gary c]

=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.