B
Bill R
I want to separate a list which is in the format item1, item2, item3, into
its component elements each part to a separate cell. The formula
=LEFT(A11,FIND(":",A11-1) will identify and return the first element (less
the comma) only but I can't find a way of achieving what I want to do. Can
someone help please?
Thanks.
Bill R
its component elements each part to a separate cell. The formula
=LEFT(A11,FIND(":",A11-1) will identify and return the first element (less
the comma) only but I can't find a way of achieving what I want to do. Can
someone help please?
Thanks.
Bill R