ExcelBanter - Looking Up Part Cell Contents

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Looking Up Part Cell Contents (https://www.excelbanter.com/excel-discussion-misc-queries/228500-looking-up-part-cell-contents.html)

Steve

Looking Up Part Cell Contents

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

Eduardo

Looking Up Part Cell Contents

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

=MID(A1,SEARCH(" ",A1)+7,10)

"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

Jacob Skaria

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

All times are GMT +1. The time now is 02:33 AM.