Forum Discussion
Solved
How to Separate data using identifier
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...
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.
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.