Create chat on new sheet in excel 2016

To create a chat on a new sheet in Excel 2016, you can use the "Text to Columns" feature. Here's how:

1. Open your Excel workbook and select the cell where you want to create the chat.
2. Go to the "Data" tab in the ribbon.
3. Click on the "From Text" button in the "Get & Transform Data" group.
4. In the "Text Import Wizard", select "Delimited Text" and click "Next".
5. In the "Delimiters" section, select "Space" as the delimiter and click "Next".
6. In the "Column settings" section, select the first column and click "Finish".

This will create a new sheet with a chat-like format, where each row represents a message and each column represents a different aspect of the message (e.g. sender, time, message text).

Here's an example of what the chat might look like:

You can customize the columns and formatting to suit your needs.