| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combining a constant and a cell value in one cell
I have a need to create a list in the fashion of
t0 t1 t2 t3 .. .. .. .. tx, where "x" is the value derived from another cell. How can I do this? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Combining a constant and a cell value in one cell
Hi
="t"&c1 if you need space between t and the number ="t"&" "&C1 Change the cell to fit you needs "Corwin" wrote: I have a need to create a list in the fashion of t0 t1 t2 t3 . . . . tx, where "x" is the value derived from another cell. How can I do this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| text in a cell invoke constant date in another cell - how | Excel Discussion (Misc queries) | |||
| Display constant cell value based on another cell value | Excel Worksheet Functions | |||
| Combining multiple cell information into one cell | Excel Discussion (Misc queries) | |||
| Constant cell | Excel Worksheet Functions | |||
| How do you convert a formula cell to a constant cell | Excel Discussion (Misc queries) | |||
Linear Mode
