Hi,

Am Wed, 2 Apr 2014 12:22:11 +0100 schrieb sumesh56:

i want to add a phrase before a word in a cell. is it possible? kindly
see the attached file.thanks

write e.g. in H10:
=IF(C4<"",$E$8&C4,"")
and copy down.
Copy the range with the formulas and paste special = paste values in C4


Regards
Claus B.
--
Vista Ultimate SP2 / Windows7 SP1
Office 2007 Ultimate SP3 / 2010 Professional