Please feel free to point me to a answer, I could not find one.
I have 2 very loaded excel file, and i need to :
- take the path from a column in excel doc 1
- Split on delimiter backslash
- Pass the splited element into new collum on the same row in excel doc 2
I feel it quite simple but i cannot find a way to do it.
path example : \Workspace\Corporate Services\IT\A Administration\A01 Associations and Organizations
I use the excel function text to column but it only work inside the same document, cannot use to export to another sheet even.