# Split the contents of a cell based on a delimiterĭf = df.str.split('-', expand=True) # Load the Excel file into a pandas dataframe Here is an example of how you could split cells in an Excel file using Pandas: To do this, you can use a library such as Pandas, which provides functions for reading and manipulating data in a spreadsheet-like format. You can split cells in an Excel spreadsheet using Python. Note: If your data contains other characters besides the dash, such as spaces, you may need to repeat the process using different delimiters to achieve the desired result. Click 'Finish' and the cell contents will be split into separate columns based on the dash.Under 'Delimiters', check the box next to 'Dash' and uncheck any other boxes.In the 'Text to Columns' wizard, select 'Delimited' and click 'Next'.Go to the 'Data' tab on the ribbon, and click 'Text to Columns'.Select the cell or range of cells you want to split.To split a cell in Excel by a dash, you can use the Text to Columns feature. So the question is: how can I do it? Method A：Excel or Google Spreadsheet I need to split these cells, and then do data analysis. I need to divide this cell (column) into one or more cells(column). In a certain cell (column), others will input the content with 'horizontal line' as the separator. I often receive these kinds of CSV or Excel files in my work.
