display text to the right of equal bar

[Dojorgen]

[TABLE="width: 568"]
<tbody>[TR]
[TD="class: xl63, width: 568"] 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 >[/TD]
[/TR]
</tbody>[/TABLE]

 

[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.