I have a cell that look like below. There is a line break between each line.
[User.x]: Bill
[User.xxxxx]: Johnathan
[User.xxx]: Erica
The amount of users within each cell varies from cell to cell as well as their names. I need to insert a second line break between each line to produce
[User.x]: Bill
[User.xxxxx]: Johnathan
[User.xxx]: Erica
so that it is all within the same cell. This needs to be done for the sake of readability. I have tried to come up with a formula that triggers every time it sees '[User.' , but the problem I am having is it only triggers on the first case. Not the second and third case. Any tips or ideas? Thank you!