Hello everyone,
Need some help here.
I have data that starts in Column A2 (goes down) that consist of data, example being 102ABCYZ@1234567
I would like to separate these values where the values are split at the "@" symbol like the following in Column B and C respectively.
B would be 102ABCYZZ...