Script\Way to insert Newline by character

[cantercrow]

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

 

[mohadin]

Hi
And welcome on board
Try

=SUBSTITUTE(A3,";",CHAR(10))

 

[Peter_SSs]

Welcome to the MrExcel board!

Perhaps something like this macro?

Sub NewRows()
  With Columns("A")
    .Replace What:=";", Replacement:=vbLf
    .WrapText = True
  End With
End Sub