=TEXT fuction

  • Thread starter Thread starter gary c
  • Start date Start date
G

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 " ")?
 
gary c said:
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 " ")?
Click to expand...

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

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

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

Thank you, very much.

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