Hi,

I frequently require to add or append perticular string in some of the cells( note: cells are in sequence or together in the column ).
It will be really helpful if we can do that in excel.

e.g.

If in perticular column, some of the column cells values are :
ABC
EFG
HIJ
KLM
OPQ

I want to add perticular string e.g. "IBM" on the beginning of the cell value.
e.g.
IBM ABC
IBM EFG
IBM HIJ
IBM KLM
IBM OPQ

Right now I just copy and paste "IBM" in each cell.

Is it possible like formula to set in formula for one cell and then drag.

Thanks,