Add Text to Column Contents
 

Hi,

Can someone please help me with an array formula for
adding 'TEST' text to all the elements in the Column A.

So the column A should look like 'TEST' + original
contents.

It should not append 'TEST' if the value is NULL.

Cheers,
Sanka

Add Text to Column Contents
 

Make a new column with formula :-
=IF(A1="","","TEST" & A1)

Select. Edit/Copy. Edit/Paste Special .. Values. then delete th
original column

--
Message posted from http://www.ExcelForum.com