Forum Discussion
exc
When you have a list made how do I make each one a separate box?
- If I understand your question correctly you might want to split text with list of items separated by some delimiter into columns or rows. If you want this to be done with formula you can use TEXTSPLIT function if you have Office 365 (documented here https://support.microsoft.com/en-us/office/textsplit-function-b1ca414e-4c21-4ca0-b1b7-bdecace8a6e7).
If I may recommend in advance, if you need an answer to your concerns, please include as much detailed information about the digital environment as possible.
Information such as Excel version, operating system, storage medium.
If possible also photos (or file, without sensitive data) with the possible error message.
Welcome to your Excel discussion space!
This way you could get a more accurate and faster solution and the others don't need to guess. Nonetheless, here are some approaches:
To make each item in a list a separate box in Excel, you can use the "Convert Text to Columns" feature. Here's how:
- Select the cells that contain the list you want to split into separate boxes.
- Click on the "Data" tab in the ribbon.
- In the "Data Tools" group, click on "Text to Columns".
- In the "Convert Text to Columns Wizard", choose "Delimited" and click "Next".
- In the "Delimiters" section, select the delimiter that separates each item in the list (e.g., comma, semicolon, tab, space).
- Preview the results in the "Data preview" section and make sure they look correct.
- Click "Finish" to split the list into separate boxes.
Each item in the list will now be in a separate cell or box in Excel.
