| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
=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 " ")? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
=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. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
=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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SUM Fuction | Excel Worksheet Functions | |||
| i need a fuction | Excel Discussion (Misc queries) | |||
| Min Fuction | Excel Worksheet Functions | |||
| IF FUCTION | Excel Worksheet Functions | |||
| need a fuction that can do this (or can it be done) | Excel Worksheet Functions | |||
Hybrid Mode
