Hi Peter Bartholomew, You are correct, to extract only number the Text format code is "0;;0;"
So, here is my formula as in:
1] Extract only number:
=CONCAT(TEXT(MID(A1,SEQUENCE(LEN(A1),1),1),"0;;0;"))
2] Extract only text:
=CONCAT(TEXT(MID(A1,SEQUENCE(LEN(A1),1),1),";;"))
Hi, Deepak, Thank...