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

You can construct similar formula using MID and RIGHT to get the other
parts, but it would be quicker to use Text-to-columns to split the
data at the comma.

Hope this helps.

Pete

On Feb 9, 4:58*pm, "Bill R" wrote:
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

Use Text to Columns. Specify comma as the delimiter.

Regards,
Fred

"Bill R" wrote in message
...
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

Hi,
highlight the column, text to columns, delimited, choose comma

the above will split each item in a different column then to right off the
comma, highlight the range, CTRL + H, find what enter , replace with left
blank

"Bill R" wrote:

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


.