Looking Up Part Cell Contents

  • Thread starter Thread starter Steve
  • Start date Start date
S

Steve

I have a cell that contains a string of information, ie. SL G12345 abcDEF123
22.04.2009

Does anyone know if there is a formula that I can put in, so that it will
extract the DEF123 element of the string to formulated cell?

Thanks
 
Hi,
Assuming that your cell is A1 and the 2nd part have 6 characters (G12345)

=MID(A1,SEARCH(" ",A1)+7,10)
 
Need more information or few more examples to ...

From the below given example you can extract DEF123 by using the below.
Assume the text string in A1

=MID(A1,14,6)

If this post helps click Yes
 
Back
Top