I would like to do the sorting with PARENT and CHILD function, can it be done without using VBA?
The attachment is copied from a txt file and generated by system.
The 1st level is "Share Documents"
2nd level has a "-"
3rd level has a "--"
4th level has a "---"
Is it possible to use function / formula to resolve this problem?
I would like to sort it with 1st level then 2nd level...but 2nd level must be follow the 1st level to do sorting.
Something like the below
Share document
-A
-B
--B1
--B2
--B3
-C
--C1
---C1i
---C2i
--C2
--C3
-D
Bookmarks