display text to the right of equal bar

[Dojorgen]

I have this string of text, what formula could i have to display to the right of the text to the left of .job so it would display MVAK0-462-A0 < Ascii JobID = MVAK0-462-A0.job >

<tbody>
</tbody>

 

[jtakw]

Hi,

A single sample may Not be a true representation of all your possible Text strings...

Based on this sample, a couple of formulas:

Book1
	A	B	C
1	< Ascii JobID = MVAK0-462-A0.job >	MVAK0-462-A0	MVAK0-462-A0
Sheet251

Cell Formulas
Range	Formula
B1	=TRIM(MID(A1,FIND("=",A1)+1,FIND(".",A1)-FIND("=",A1)-1))
C1	=TRIM(MID(SUBSTITUTE(A1,".",REPT(" ",99)),FIND("=",A1)+1,99))

 

[Scott Huish]

If you're lead-in text is always the same:
=SUBSTITUTE(MID(A1,15,255),".job","")

If it can be different:
=SUBSTITUTE(TRIM(REPLACE(A1,1,FIND("=",A1&"="),"")),".job","")

 

[Dojorgen]

thanks everyone works perfect

 

[jtakw]

You're welcome.