Extracting Text/Numbers from an AlphaNumeric String.

Extracting Text/Numbers from an AlphaNumeric String.

Dear Forum,

I am in need of seperating Numbers and Alphabets joined by a Special Character..

Ex:

1> AAA/BBB


I want to get "AAA" as well as "BBB"


2> 123/456

I want to get "123" as well as "456"


3> 12/345

I want to get "12" as well as "345"

4> 123/45

I want to get "123" as well as "45"


I tried the below code but it failed

=RIGHT(A$1,LEN(A$1)-FIND("/"A$1,1))-LEFT(A$1,LEN(A$1)-FIND("/",A$1,1))

This failed in these two cases

3> 12/345

4> 123/45

Warm Regards
e4excel