Split a String in 3 columns for Characters and Numeric entries mixed

[prkhan56]

Dear All
I am using Excel 2016 and want to split a string mix of characters (C) and numbers (N) in three columns

Before (1 Column)
CC NNxNNNg CC
CCC NNxNNNg CCCC
CC CC CCCCC NNxNNNg CC
CCC NNxNNNg CC
CCCCCCC CCCC CC NNxNNNg CC
CC NNxNNNg CCCCCCCC
CCCC CCCCC NNxNNNg CCCCC CCCC
CCCCC CCCCCCC CCCCCC NNxNNNg CC
CC NNxNNNg CC

After in 3 Columns as follows:
I have put spaces between the three columns but it does not show on the post
1st Column 2nd Column 3rd Column
CC NNxNNNg CC
CCC NNxNNNg CCCC
CC CC CCCCC NNxNNNg CC
CCC NNxNNNg CC
CCCCCCC CCCC CC NNxNNNg CC
CC NNxNNNg CCCCCCCC
CCCC CCCCC NNxNNNg CCCCC CCCC
CCCCC CCCCCCC CCCCCC NNxNNNg CC
CC NNxNNNg CC

Just to explain further all the CCCs will be in the 1st Column and the NNxNNNg in second column and the last CCCs coming after the character g will be in third column
Any help would be appreciated

 

[sandy666]

maybe post example in table form

 

[prkhan56]

maybe post example in table form

How can I do that?

 

[Eric W]

Like this?

Book1
	A	B	C	D
1	CC 12x345g CC	CC	12x345g	CC
2	CCC 23x456g CCCC	CCC	23x456g	CCCC
3	CC CC CCCCC 44x555g CC	CC CC CCCCC	44x555g	CC
4	CCC 66x666g CC	CCC	66x666g	CC
5	CCCCCCC CCCC CC 77x777g CC	CCCCCCC CCCC CC	77x777g	CC
6	CC 88x999g CCCCCCCC	CC	88x999g	CCCCCCCC
7	CCCC CCCCC 98x765g CCCCC CCCC	CCCC CCCCC	98x765g	CCCCC CCCC
8	CCCCC CCCCCCC CCCCCC 54x321g CC	CCCCC CCCCCCC CCCCCC	54x321g	CC
9	CC 11x222g CC	CC	11x222g	CC
Sheet13

Cell Formulas
Range	Formula
B1	=TRIM(LEFT(A1,AGGREGATE(15,6,FIND({0,1,2,3,4,5,6,7,8,9},A1),1)-1))
C1	=TRIM(LEFT(SUBSTITUTE(SUBSTITUTE(A1,B1,""),"g",REPT(" ",LEN(A1))),LEN(A1)))&"g"
D1	=TRIM(MID(A1,SEARCH("g",A1)+1,LEN(A1)))

 

[prkhan56]

Dear Eric
Thanks a lot for time and help

 

[Eric W]

Glad we could help.