Strip characters before and after a certain char such as "A1"

[imoree]

hello everyone;

i just can't seem to figure this one out.

I am looking to find a certain range of chars such as A1, then strip chars before and after but don't know how.

here is what i have so far. I just need it finished.

* ok. while i was writing this, i saw that i figured out my own problem

Here is the solution for anyone else;

Let([

		 text = "1ASdfdA1sdjf1231123";						 //string to search for ;

		 search = "A1";												  // i am looking for A1

		 location = Position ( text; search ; 1; 1);		  // where does this start @

		 sectionR = Right ( text; location);					 // find right section

		 sectionL = Left( text; location)						  // find left section

	   ];

		 right( sectionL ; 1) & left( sectionR ;1 )			 //we know right and left so lets strip off 1 char off each and we get proper			result

)