Dec 17 2021 05:53 AM
Hey,
I have a row with ad names like "Video_8_2021-12-01 12:00:29" or "Video_7_2021-12-01 12:00:29".
I want to make a new row only with the real names like "Video_8" or "Video_7".
Currently it is only possible for me to do it, with one row. This is my function currently
=WENN(ISTFEHLER(FINDEN("Video_1";B6;1));"";"Video_1")=WENN(ISTFEHLER(FINDEN("Video_1";B6;1));"";"Video_1")
Do you know how I can solve my problem and do it for alle rows and use a function so that in the end there is the row like:
Video_1
Video_2
Video_7
Video_2
etc...
Thank you and best regards
Dec 17 2021 06:09 AM
Dec 17 2021 06:18 AM
As done in the attached file you can manually type "Video_8" in cell c6 and then apply flashfill by pressing ctrl+E.
Dec 17 2021 07:38 AM
SolutionDec 17 2021 07:45 AM
Dec 17 2021 08:13 AM
@jeffraybo Precisely. Personally, I favour such a formula over Flash Fill. But that's just my own preference.
Dec 18 2021 05:49 AM
In addition to @Riny_van_Eekelen comment. FlashFill, especially on relatively large or not well structured data could give incorrect results. It have to check carefully what is returned by FlashFill to be sure result is correct.
Dec 17 2021 07:38 AM
Solution