Quote:
Originally Posted by Claus Busch
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
|
Claus Busch,
thanks a lot for the macro. it works
perfect. can you find time to explain
what you meant by Rows,count 3?
I want to learn it so that i can use it
in different situations. I would like to
know how would you edit your macro to
suit to the new file attached.have a nice
day.
I would like to see that after merging
the strings, i would delete Mystring and
the result should maintain.
have a nice day.