| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditionally formatting just part of a cell contents - how? | Excel Worksheet Functions | |||
| #N/A if cell contents not part of an array | Excel Discussion (Misc queries) | |||
| Combining Cell Contents (Part 2) | Excel Discussion (Misc queries) | |||
| Displaying cell contents as part of a formula | Excel Worksheet Functions | |||
| Can I use cell contents as part of a formula? | Excel Worksheet Functions | |||
Hybrid Mode
