The Text to Columns feature allows splitting a single cell into multiple cells by placing a specified delimiter depending on…