Excel Help with related to Left Right Mid function

[Jyotirmaya]

The sample text data in my sheet are like the following,

example

Peter England, * Shirt / UK in a single cell. I need Peter England in a different cell Shirt in a different cell UK in a different cell.

I am using the following function
B1 =LEFT(A1,FIND(",",A1)-1) for getting Peter England in B1

I need two more functions to get Shirt in C1 & Uk in D1

I am trying =RIGHT(A1,LEN(A1)-FIND("*",A1)*1) but with that code I am getting Shirt/UK
I need Shirt in different cell and UK in different cell.

<colgroup><col width="115"></colgroup><tbody>
[TD="width: 115"]
[TABLE="width: 115"]
<colgroup><col></colgroup><tbody>[TR]

</tbody>

[/TD]
[/TR]
</tbody>[/TABLE]

 

[Roderick_E]

Part of the problem is because "*" is used for wildcards in Excel so it isn't actually finding *.
My code assumes the original text is in A1...
in B1 place:

=LEFT(A1,SEARCH(",",A1)-1)

in C1 place:

=SUBSTITUTE(MID(A1,SEARCH(", * ",A1),SEARCH("/", A1)-SEARCH(", * ",A1)),", * ","")

in D1 place:

=TRIM(MID(A1,SEARCH("/",A1)+1,99))

 

[Jyotirmaya]

Thank you Roderick its working