Thank you very much for creating this helpful video. For the data without a space at the end, you can try the following formula: MID(A3,SEARCH(E1,A3)+LEN(E1),LEN(A3)-SEARCH(E1,A3)-(LEN(E1)+1)
You could use the iferror function to create two more cases:one where you have only two exercises and another when you have only one instead of placing a zero, right? Also for the last qustion could you delete the space after the search? Something like minus one after the search?
Thank you very much for creating this helpful video. For the data without a space at the end, you can try the following formula: MID(A3,SEARCH(E1,A3)+LEN(E1),LEN(A3)-SEARCH(E1,A3)-(LEN(E1)+1)
I knew some smart will answer, as I put a comment. Question: How do I know which is last ? say the excel and thousands of rows.
Fantastic video, really useful!
I love Excel and great contributors like yourself!
Thank you so much for your kind help!
You could use the iferror function to create two more cases:one where you have only two exercises and another when you have only one instead of placing a zero, right?
Also for the last qustion could you delete the space after the search? Something like minus one after the search?
Thank you thank you thank you :)
Aha, this formula expects that the A column data ends with " " or the last items will fail.