I wonder what "*" means and what "Sometime the above marked string is
broken to next row" means. Is the marked string, in your case, "aa",
"111111_aa", "125.00", "125.00" and "0.0"? Is the "*" just a delimiter
or something else? Do you just want to find the strings of 111111_aa,
125.00 and 0.00 in a long string in the cells or something else?

Keiji

yagna wrote:
Hi,

I have the string in the Excel file where the
"\abc*aa**11111_aa*125.00*125.00*0.0\ " I need to split this data from the
long string stored in the cell. Sometime the above marked string is broken to
next row. how do I split this in macro & to find out when it is split in the
different but continuous row.

Split required are
Col A -111111_aa
Col B -125.00
col C-125.00
Col D-0.00

Thanks & regards,
yagna.