How to split text values by a delimiter

Question

I must examine a database. I want to use the delimiter @ to merge all of the necessary cells together. I now want to use the @ delimiter to divide the string value on a different sheet (see the screenshot). It must be carried out using a formula.

Answer 1

The Split function is what you are looking for:

=Split(A1, "@")

Example of Split used to split text by delimiter