Greetings, we continue our series of posts this week that show how you can get help from copilot with the chat helper. Copilot in Excel can help you to find the right function for a task and can also help you if you know what function you want to use but need help with an example. We’ll show this by asking Copilot in Excel the following question:

Can you give me an example of how to use =textafter in Excel?

Copilot in Excel analyzes the question and returns the response below, explaining how to use the TEXTAFTER function:

Picture of Copilot in Excel pane showing the above prompt with a description of the TEXTAFTER function and how to use it.

“Certainly! The =TEXTAFTER function in Excel is used to extract text that comes after a specific delimiter in a given string. Here’s an example of how to use it:

Suppose you have a list of email addresses in column A, and you want to extract the domain part of the email (the part after the “@”). You can use the =TEXTAFTER function to do this.

Here’s the formula you would use in cell B1 and then drag down to apply to other cells in the column:

=TEXTAFTER(A1, “@”, , 1)

A1 is the cell containing the email address.
“@” is the delimiter after which you want to extract the text.
The third argument is left blank to use the default behavior, which is to return the text after the first occurrence of the delimiter.
1 specifies that you want to extract the text after the first occurrence of the “@” symbol.

If the “@” symbol is not found in the text, the function will return an error by default. You can modify the behavior by adding an additional argument to specify a different outcome when the delimiter is not found.”

Over the coming weeks I will be sharing more examples of what you can do with Copilot in Excel.

Thanks for reading,

Microsoft Excel Team

*Disclaimer: If you try these types of prompts and they do not work as expected, it is most likely due to our gradual feature rollout process. Please try again in a few weeks.

​Greetings, we continue our series of posts this week that show how you can get help from copilot with the chat helper. Copilot in Excel can help you to find the right function for a task and can also help you if you know what function you want to use but need help with an example. We’ll show this by asking Copilot in Excel the following question:
Can you give me an example of how to use =textafter in Excel?
Copilot in Excel analyzes the question and returns the response below, explaining how to use the TEXTAFTER function:
Picture of Copilot in Excel pane showing the above prompt with a description of the TEXTAFTER function and how to use it.
 
“Certainly! The =TEXTAFTER function in Excel is used to extract text that comes after a specific delimiter in a given string. Here’s an example of how to use it:
Suppose you have a list of email addresses in column A, and you want to extract the domain part of the email (the part after the “@”). You can use the =TEXTAFTER function to do this.
Here’s the formula you would use in cell B1 and then drag down to apply to other cells in the column:
=TEXTAFTER(A1, “@”, , 1)

A1 is the cell containing the email address.
“@” is the delimiter after which you want to extract the text.
The third argument is left blank to use the default behavior, which is to return the text after the first occurrence of the delimiter.
1 specifies that you want to extract the text after the first occurrence of the “@” symbol.

If the “@” symbol is not found in the text, the function will return an error by default. You can modify the behavior by adding an additional argument to specify a different outcome when the delimiter is not found.”
 
Over the coming weeks I will be sharing more examples of what you can do with Copilot in Excel.
 
Thanks for reading,
Microsoft Excel Team
 
*Disclaimer: If you try these types of prompts and they do not work as expected, it is most likely due to our gradual feature rollout process. Please try again in a few weeks.  Read More

​