return value

[biggoan]

I have a cell that has xxxxxx=xxxxxxxxxxxx=xx= I want the first four char after the first = sign to be put in a differnt cell, how can I do that?

 

[Fergus]

If it's in A1 use =MID(A1,FIND("=",A1,1)+1,4)

 

[sweater_vests_rock]

biggoan.

Try this, where C1 is the cell containing the entry to search:

=MID(C1,SEARCH("=", C1)+1,4)

Hope that helps. Ben.

 

[biggoan]

Works like a charm thanks guys