Not sure if there is a way where you can search/Find a specific word using an excel formula, For Example the word"Week" and if Week is found in the cell, then it returns the next 6 or 7 characters?
So it would take the commentry out of cell A2 and if the word "Week" is visible, it would show week 11 in cell B2.
So it would take the commentry out of cell A2 and if the word "Week" is visible, it would show week 11 in cell B2.