hi friends,

I am new to VBA excel scripting.. I need a script that fulfills the following conditions..

I have an excel sheet which contains the data as the following


"""To:sara;
cc: abi; pup; """
"""To: loe, frez;Str, Peo; lrson
Cc: IT; GS; """
"

each cell in the first column contains the same data.. now I need the output as follows

sara
abi
pup
loe,frez
str,Peo
irson
IT
GC

which means the characters ; : " should be replaced with line break.. and the names should be displayed in the second sheet or some other column one by one.. but in the same column..


could u please help me to do this.. many thanks in advance