Excel's TEXTSPLIT function can split words into separate cells. You can have multiple delimiters, you just have to know how to define these properly. You can also do amazing things like splitting into columns and rows and internally sorting words.
If you're a Mechanical Engineer, make sure you know these 10 Excel functions. Your work-life will become much easier once you learn these Excel formula combinations.
Sometimes the data you copy or import into Excel has stubborn spaces that can't be removed with the TRIM function. You need a different function to remove these nonbreaking spaces. Something that acts like a TRIM ALL function in Excel.
