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
Bookmarks