Sure, I can help you with that. Here are the
steps to split the text into multiple columns using a common delimiter:
- Select the column that contains the data you want to split (in this case, column A).
- Click on the "Data" tab in the ribbon at the top of the screen.
- Click on the "Text to Columns" button in the "Data Tools" group.
- In the "Convert Text to Columns Wizard" that appears, select "Delimited" and click "Next".
- In the next screen, select the delimiter that separates the data in your column (in this case, the asterisk "*") and click "Next".
- In the next screen, you can choose the format of the columns you want to create. For this example, select "General" for both columns B and C and click "Finish".
- Your data should now be split into two columns, with the data preceding the "*" in column B and the data following the "*" in column C.
That's it! Your data should now be split into two columns based on the common delimiter.