Hello friends i need a formula in excel to separate the mobile number and zip code into different cells

Here is my sample cell to separate.
Bellow total in one cell so i need a 3 different cells for address, mobile number, zip code.

24 103/1/1/A, LAXMI NARAYANA NAGAR, UPPAL, HYDERABAD, HYDERABAD, TELANGANA,9866256934, 500013

Thanks in advance

Try this

Hello,

I am not familiar with your county's ZIP/Phone numbers, but these formulas work under the assumption that the Zips are always 6 digits, the phone number is always 10 digits, and there is a space before the zip code and no spaces before and after the phonenumbr (like your above example).

Here is how I have it set up for these formulas to pull exactly as written:

Address:

=LEFT(A2,SEARCH(C2,A2)-2)

 

Mobile:

=LEFT(RIGHT(TRIM(A2),18),10)

Zip:

=RIGHT(TRIM(A2),6)