Excel: Flash Fill not exact

[MSCom]

Hi,


I am using Flash Fill in order to separate Names for sample:


Nicole Nice

Minni Magic

...


Now I have names with doubled name or with hyphen in between for sample:


Nicole-Nora Nice or

Minni Mona Magic


Is there a way to get correct results with Flash Fill showing Nicole-Nora or Minni Mona as First name instead of Nicole and Minni?


My suspicion is that I will have to use a formula for that but I was wondering if this is also possible to do with Flash Fill.


Any Ideas?


All the best,


Nicole