Split cell data

Hi,

In A1 i have a data like "h1/h2/h1/h3" and i need to return "h1/h2/h3" in cell A2(ignoring repeated data(h1)).

Any reply would be helpful.

Thanks,
Spice

Hello spice,
Would a UDF be ok?

Please Login or Register  to view this content.

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save