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.

1 comment:

  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