Excel – How to add content to Excel cells

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:

  1. insert a new column, I'll call it B, next to your data column, which I'll call A.
  2. set the value in cell 1 of the column to: =A1 & "T" (this appends a "T" to the end of the cell, if you need it at the beginning you can write ="T" & A1)
  3. grab the cell-extender box thingy (sorry, I can't think of its proper name) at the bottom-right corner of the highlighted cell) and drag down 10,000 cells, and then let go. Your formula is replicated all the way down, with cell references automatically adjusted.
  4. If you really want the 'T'-added values in the original column, copy column B, then right-click on the column A header and choose "Paste Special...", choose "Values", and click OK. Then delete column B. Warning: if column A uses formulas to display its data, this will destroy those underlying formulas, leaving only the values!