Splitting out text in to columns

Brass Contributor

I'm trying to get Text in Column A split into the 4 columns

for example this: 2CMOWest 2OMJ4-5” split like :

excel_learner_1-1643821578013.png

 
 

Is there a formula I can use for this without having a delimiter ?

 

1 Reply
Try Flash Fill.