View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Eduardo Eduardo is offline
external usenet poster
 
Posts: 2,276
Default 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?