View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Jacob Skaria Jacob Skaria is offline
external usenet poster
 
Posts: 8,520
Default Looking Up Part Cell Contents

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
---------------
Jacob Skaria


"Steve" wrote:

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