| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Extract Part of a Cells Contents Q
I saw yesterday a post on extracting art of a cells contents, I have
tried to twaek it to fit my requirements but am lost as to how to. The formula that I tried to tweak is: ="Accounts for Period - "&LEFT(TRIM(MID(A2,FIND("-",A2)+1,99))&" ",FIND(" ",TRIM(MID(A2,FIND("-",A2)+1,99))&" ")-1) - The will return "Accounts for Period - October'08" The Text in A2 is ^Accounts Reconciliation - October'08 (at 08/11/2008) What I want to extract is only the text 08/11/2008 - i.e. everything within the brackets, but not the brackets themselves or the word 'at' |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Extract part of a cell | Excel Worksheet Functions | |||
| Extract part of a text string | Excel Worksheet Functions | |||
| How do I extract part of a text string | Excel Discussion (Misc queries) | |||
| Can I search a cell for a value and extract part of content? | Excel Discussion (Misc queries) | |||
| Extract Part of String | Excel Worksheet Functions | |||
Threaded Mode
