find and remove a string of a cell value with comma as delimiter
can anyone help me on this?
i have columns of data which has the format of (something1,something2,
something3, others)
the string "somthing1", "somthing2", "somthing3" are consistent, and
not all may appear at the same time, while the part "others" may vary.
I want to extract the "others" part, if the cell has
how can i do this in a macro?
i donot want to modify the original cell, but will store the "others"
in another sheet
|