After using TEXTJOIN function to join the texts then while trying to split the text using "text to column" feature, it splits the function's formula and not the value in the cell. Please assist in priority.
