Forum Discussion
Replace "," with a "Newline" in Excel
Dear Experts, I have a query like below ;- In Column "A", I have data like below, and need Output like in Column "D" ; Thanks in Advance, Br, Anupam
Replace YourTableName belows with your actual Table name:
= TOCOL(
HSTACK(
TEXTBEFORE(YourTableName[RLC-NR_Sequence Numbers(Subcell-9)],","),
TEXTAFTER(YourTableName[RLC-NR_Sequence Numbers(Subcell-9)],",")
)
)
