How can I add a T
to the content of each cell in a certain column (that contains 10000 cells) without typing it manually?
Excel – How to add content to Excel cells
microsoft excelmicrosoft-officespreadsheet
microsoft excelmicrosoft-officespreadsheet
How can I add a T
to the content of each cell in a certain column (that contains 10000 cells) without typing it manually?
Best Answer
The non-programming way:
=A1 & "T"
(this appends a "T" to the end of the cell, if you need it at the beginning you can write="T" & A1
)