Question: how do you separate 1 cell into 2 in excel?
Answer: Select the cell or cells whose contents you want to split. ...  On the Data tab, in the Data Tools group, click Text to Columns. ...  Choose Delimited if it is not already selected, and then click Next.