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

=A1&"text"

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.

2 comments:

  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

    ReplyDelete
  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

    ReplyDelete