Collect data after IF statement

[JTL9161]

I have this data starting in A1. I need to copy the text after the "xx" but not every line with start with "xx". Need formula to take text after "xx" if there, if not just need the text.

xx ABCDEFGHI trying to get ABCDEFGHI
JKLMNOPQR trying to get JKLMNOPQR
xx 12345678 trying to get 12345678
STUVWXYZ trying to get STUVWXYZ

Thanks,
James

 

[AhoyNC]

Try:

Book1
	A	B
1	xx ABCDEFGHI trying to get ABCDEFGHI	ABCDEFGHI trying to get ABCDEFGHI
2	JKLMNOPQR trying to get JKLMNOPQR	JKLMNOPQR trying to get JKLMNOPQR
3	xx 12345678 trying to get 12345678	12345678 trying to get 12345678
4	STUVWXYZ trying to get STUVWXYZ	STUVWXYZ trying to get STUVWXYZ
Sheet2

Cell Formulas
Range	Formula
B1:B4	B1	=TRIM(IFNA(TEXTAFTER(A1,"xx"),A1))

 

[Fluff]

How about

=TEXTAFTER(A1,"xx ",,,,A1)

 

[Coyotex3]

Maybe something like this

 =IFERROR(TEXTAFTER(A1,"xx "),A1)

Fluff's answer above is a much better option.

 

[JTL9161]

Try:

Book1
	A	B
1	xx ABCDEFGHI trying to get ABCDEFGHI	ABCDEFGHI trying to get ABCDEFGHI
2	JKLMNOPQR trying to get JKLMNOPQR	JKLMNOPQR trying to get JKLMNOPQR
3	xx 12345678 trying to get 12345678	12345678 trying to get 12345678
4	STUVWXYZ trying to get STUVWXYZ	STUVWXYZ trying to get STUVWXYZ
Sheet2

Cell Formulas
Range	Formula
B1:B4	B1	=TRIM(IFNA(TEXTAFTER(A1,"xx"),A1))

Thanks, works perfectly

 

[Coyotex3]

How about

=TEXTAFTER(A1,"xx ",,,,A1)

I'm just now realizing that there is a if not found argument in the text formulas!

 

[AhoyNC]

Fluff's answer is the better one. If there could be more than one space after the "xx" then.
=TRIM(TEXTAFTER(A1,"xx",,,,A1))