Wednesday, November 23, 2011

How to add text to cells in Excel

If you want to add textual prefix or suffix to multiple cells of a row/column/table in Excel use the following formula:

to add suffix to the cell A1


then simply copy the cell (CTRL + C) and paste into all cells that you want to modify. All cells will be given the same suffix.


  1. Thanks for sharing your info. I really appreciate your efforts and I will be waiting for your further write ups thanks once again.
    html5 media player

  2. The purpose of the Excel application is to allow users to collect like data in a specific location for current and/or future use.
    excel reporting dashboard

  3. Excel programmers have made wide mark when they created Excel business programming solutions. salesforce datawarehouse