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.