=TEXTSPLIT

https://www.ablebits.com/office-addins-blog/textsplit-function-excel-split-cells-strings/

Excel TEXTSPLIT function

TEXTSPLIT availability

Basic TEXTSPLIT formula to split a cell in Excel

Split a cell horizontally across columns

Split a cell vertically across rows

Split text by substring

Split string into columns and rows at once

Separate cells by multiple delimiters

Split text ignoring empty values

Cell splitting case-sensitive or case-insensitive

Pad missing values in 2D array

Split dates into day, month and year

Split cells and remove certain characters

Split strings skipping certain values

TEXTSPLIT alternatives

Sling TV sells your email address

I signed up to Sling with an email address that I created solely for Sling membership, however, I have been getting SPAM into that email address. My only reasoning is that they sold my email address. I created an email sch as TV@domain.com, which was meant only for Sling TV. How can other people know my email address if I only gave it to Sling? When you set up you account for services like Sling, Roku, etc., create a unique address for those services, that way you know who’s selling your “private” information.