Splitting Text String into multiple Cells

[mummbles74]

I have a text string that is a consistent format seperated by - I would like to split the text into 5 different column into the different elements. Assuming the main string is in C1 I would like the data split across the same row in column D:G An example of the text string is as follows: WARRN-SL1-ST1-PDI01-MI001

As an addition would their be a way to send an error if the string did not meet this format?

 

[Georgiboy]

Maybe:

=LET(d,TEXTSPLIT(C1,"-",,TRUE),IF(COUNTA(d)<5,"Error",d))

But this depends on how one views:

As an addition would their be a way to send an error if the string did not meet this format?

Currently the check it does is make sure there ar 5 parts to the string

Book1
	A	B	C	D	E	F	G	H
1			WARRN-SL1-ST1-PDI01-MI001	WARRN	SL1	ST1	PDI01	MI001
2			123	Error
3			WARRN-SL1-ST1-PDI01	Error
Sheet1

Cell Formulas
Range	Formula
D1:H1,D2:D3	D1	=LET(d,TEXTSPLIT(C1,"-",,TRUE),IF(COUNTA(d)<5,"Error",d))
Dynamic array formulas.

 

[mummbles74]

Many thanks just what I was looking for.

 

[Georgiboy]

You are welcome