News

To get started, open the Excel Sheet in which you would like to split a single column into multiple columns. Then, go to the ‘ Data ’ tab and select the ‘ Text to Columns ’ section.
Use the TEXTSPLIT Formula . Another easy way to separate first and last names is using the TEXTSPLIT Excel function.This ...