Flash Fill lets you join, split and manipulate data based on patterns that you enter, no formulas are required!

Watch this video to get started.

[embedyt] https://www.youtube.com/watch?v=0BySmdFz6Sw[/embedyt]