Hi,
I have spent hours trying to come up with a solution to the below. I would really appreciate any help.
I have data in the following format in the A column:
Backlog, Release 1, Release 1 Iteration 12
Backlog, Release 1, Release 1 Iteration 13 (First Pass)
Backlog, Release 1 Iteration 12, Release 1
Backlog, Release 1 Iteration 14 (Second Pass), Release 1
What I could like it to read in the text and look for anything with "Iteration" and return the bit between the commas. If iteration is at the end then just return the end bit after the final comma.
The result would be:
Release 1 Iteration 12
Release 1 Iteration 13 (First Pass)
Release 1 Iteration 12
Release 1 Iteration 14 (Second Pass)
I'm not sure if this is possible using standard excel functions since the length of the sub-string is not fixed and can change depending on what it is named as.
Many thanks in advance.
Bookmarks