Hi Martin Fishlock,JAVB
Thank you very much for your responses.

JAVB,
Column2 is the column2 where I need to place the concatenated text

Martin Fishlock,
The solution worked fine as I required ! There is one small problem
I am facing.It is like this :-
I need to concatenate the rows only if a row starts with some word.Here
is an example :-
Column1 | Column2
A:XXX | A:XXXB:YYYC:ZZZ
B:YYY |
C:ZZZ |


In case any row does not have either A, or C as the starting word then
I want to combine the row with the earlier row which is having one of
A,B,C.Here is the example
Column1 | Column2
A:XXX | A:XXXMMMB:YYYNNNC:ZZZ
MMM |
B:YYY |
NNN |
C:ZZZ |


Can you please advise on how to go about this ?

Thanks
Tushar Johri


--
tushar_johri
------------------------------------------------------------------------
tushar_johri's Profile: http://www.excelforum.com/member.php...o&userid=30181
View this thread: http://www.excelforum.com/showthread...hreadid=499356