cantercrow
New Member
- Joined
- Jun 6, 2023
- Messages
- 1
- Office Version
- 365
- 2021
- 2019
- Platform
- Windows
Hi,
I have a lot of cells with long lines of data separated by a semicolon ;, I am looking for a way with word wrap enabled on the cell insert a new line after each semicolon to make it more readable for a report.
For example:
Before
data1;data2;data3;data4;
After
data1
data2
data3
data4
Thanks
I have a lot of cells with long lines of data separated by a semicolon ;, I am looking for a way with word wrap enabled on the cell insert a new line after each semicolon to make it more readable for a report.
For example:
Before
data1;data2;data3;data4;
After
data1
data2
data3
data4
Thanks