Hi, I am having an issue in creating a formula for a task. I have a column of cells that contain a massive string. This string holds the name of a user in between the characters "CN=" and ",OU".
I am currently using this formula: =IFERROR(MID(LEFT(F5,FIND(",OU",F5)-1),FIND("CN=",F5)+3,LEN(F5)), "Orphan")
This works for the first value, but I would like for it to continue to extract substrings until the cell is empty.
Any help would be greatly appreciated!!
Bookmarks