How to split text values by a delimiter?

Question

I need to analyze a database. I want to merge all cells I need with each other with a delimiter @. Now, I want to separate the string value in another sheet by the @ delimiter (see the screenshot). It needs to be done via a formula.

Answer 1

If I understand you correctly, the Split function should do what you want. e.g.:

=Split(A1, "@")

Example of Split used to split text by delimiter