Tex Split Formula

[ChetanPuri]

Good Morning All,

I have a text split formula question, I have number of Accounts where I would like to separate last 3 digits and then in the next column 121 and petty cash are split. Many thanks for all your help.

Book1
	A	B	C
2	10.11.100.121 Petty Cash	121	Petty Cash
Sheet1

 

[Cubist]

Try:

Book1
	A	B	C
2	10.11.100.121 Petty Cash	121	Petty Cash
Sheet11

Cell Formulas
Range	Formula
B2	B2	=TEXTBEFORE(TEXTAFTER(A2,".",-1)," ")
C2	C2	=TEXTAFTER(TRIM(A2)," ")

 

[ChetanPuri]

Try:

Book1
	A	B	C
2	10.11.100.121 Petty Cash	121	Petty Cash
Sheet11

Cell Formulas
Range	Formula
B2	B2	=TEXTBEFORE(TEXTAFTER(A2,".",-1)," ")
C2	C2	=TEXTAFTER(TRIM(A2)," ")

Thank you so much, it was really helpful. Many thanks

 

[Rick Rothstein]

Put this formula in cell B2 and it will fill both B2 and C2 with the text you seek...

=TEXTSPLIT(SUBSTITUTE(TEXTAFTER(A2,".",-1)," ","|",1),"|")