Microsoft Excel: Quickly add same text to several cells

By: Staff Date: December 07, 2007 Recommended by: readers |

For that we will use the function “concatener”.

If you have a column containing of alias for example (i.e. the part before “@” in an address email) place in a blank column and enter “=CONCATENER ()”.

Between the 2 brackets enter the number of the first cell of alias (A1 for example) then one “; ” then between quotation marks the characters which you wish add.

You obtain: =CONCATENER (A1; “@softwaretipspalace.com”)

If a1 cell contained “Borisz” you obtain in your cell “borisz@ softwaretipspalace.com”

To extend this formula to the entire column, position your cursor with the corner of the cell containing the formula and also stretch this one far you want it, slacken and here.

Digg this!

Add to del.icio.us

Slashdot it!

Furl it!