splitting specific text

[Ramballah]

Hi all,

I have a sheet with where a lot of cells have text in their cell that I need to split.
See the following:

As you can see a lot of cells have "(New) Mail Periodieken" (not all cells)
I want to split that part so I tried using the =right formula but many cells have different lengths.
Data text to columns didn't help me much either. Is there a way this can happen? I need everything after "Periodieken" in a different cell, and if it does not have that specific "(New) Mail Periodieken" part then it doesn't need to split.
Assume this is column A, row 1 to 20
I hope I gave enough information, if not let me know!
Thanks in advance,
Ram

 

[AlanY]

will this work for you?

=SUBSTITUTE(A1,"(New) Mail Periodieken ",,1)

 

[bebo021999]

In B1:

=SUBSTITUTE(A1,"(New) Mail Periodieken ","")

 

[Ramballah]

In B1:

=SUBSTITUTE(A1,"(New) Mail Periodieken ","")

thank you this works like a charm

 

[rjmdc]

why would you use formula instead of Power query?

 

[Peter_SSs]

why would you use formula instead of Power query?

Why wouldn't you use a (simple) formula?

 

[rjmdc]

beacuse then any file i send to the query will do the exact same thing
i alos know and undertsand query better than formulas
i wanted to know if formula is faster or more efficient

 

[Peter_SSs]

i wanted to know if formula is faster or more efficient

Well, you have been given one to test.