formula to transpose value within the cell

Need a formula transpose a value seperated by  colon into the same cell

EG: 

 

192.168.1.1:192.168.1.2:192.168.1.3:192.168.1.4

I want the data to be like below in the same cell

192.168.1.1
192.168.1.2
192.168.1.3
192.168.1.4
 

By: kcsub

One thought on “formula to transpose value within the cell

  1. andrew walker Post author

    Hi, does the list appear in a single cell in its original form you want to transpose it?

Leave a Reply

Your email address will not be published. Required fields are marked *