Add Text to Column Contents

  • Thread starter Thread starter Sanka
  • Start date Start date
S

Sanka

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
 
Make a new column with formula :-
=IF(A1="","","TEST" & A1)

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