Right, Left, Mid, Trim

[Frank Bacchus]

All:


What would the formula be for splitting this in four separate columns:


xs-angie.brian.ann.teom.org suv76.hippo.Xa.mintten.teom.org 9823 123.69.8.155


Col1 Col2 Col3 Col4
xs-angie.brian.ann.teom.org suv76.hippo.Xa.mintten.teom.org 9823 123.69.8.155


Appreciate it and thanks in advance.


frank

 

[AliGW]

Data ribbon - Text to Columns - use the space as the delimiter. Bob's your uncle!

 

[Frank Bacchus]

thanks.

 

[AliGW]

You’re welcome!