How to Separate data using identifier

[Sridhar0311]

Hi All,

I want to extract data from a specific cell by using an Identifier like ( , . - ).

For Example : From  "School.Data.Boys.Girls.Parents" , I need to extract "School.Data.Boys.Girls" In one cell & "Parents" in another cell.

Any Insights are highly appreciated. 

Thanks

Sridhar 

[#2 · Accepted solution]

@Sridhar0311 

Let's say the text is in A1.

To get the first part:

=TRIM(LEFT(SUBSTITUTE(A1,".",REPT(" ",255),LEN(A1)-LEN(SUBSTITUTE(A1,".",""))),255))

and for the last part:

=TRIM(RIGHT(SUBSTITUTE(A1,".",REPT(" ",255),LEN(A1)-LEN(SUBSTITUTE(A1,".",""))),255))

These formulas can be filled down if required.

[#3]

 @Hans Vogelaar  Thanks for your support