I have a string column with displayNames joined with /n. There could be 1-20 names. I need a formula for extracting first names and another for last names while keeping the line breaks.
Thanks for any help!
Example: Lee, Sara\nCrocker, Betty\nHines, Duncan\nJim, Slim
Desired outputs:
Formula 1: Lee\nCrocker\nHines\nJim
Formula 2: Sara\nBetty\nDuncan\nSlim
