ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Combining a constant and a cell value in one cell (https://www.excelbanter.com/excel-discussion-misc-queries/230616-combining-constant-cell-value-one-cell.html)

Corwin

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?

Eduardo

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?



All times are GMT +1. The time now is 09:04 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com