| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Extract Part of String
Hi There,
Is there a formula with which I can extract part of a text-string ... After the First "." and before first "Blank Space"? eg. Ped.Dry BeuatifulWeather.30 =results: Dry Ped.VeryWet HellBreak.15 = VeryWet Ped.Dry LA.La lala = Dry .... All help, sugestions welcome Sige |
|
#2
|
|||
|
|||
|
wrote...
Is there a formula with which I can extract part of a text-string ... After the First "." and before first "Blank Space"? .... =MID(x,FIND(".",x)+1,FIND(" ",x&" ",FIND(".",x))-FIND(".",x)) The point of the &" " is to avoid errors when there are no spaces after the initial period, in which case the formula above returns the entire substring to the right of the initial period. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| select part of a cell value string | Excel Discussion (Misc queries) | |||
| Extract hyperlink string from excel cell | Links and Linking in Excel | |||
| vlookup to extract part cell content | Excel Discussion (Misc queries) | |||
| Extract % from text string | Excel Worksheet Functions | |||
| How do you extract numbers from a string of chacters in a cell (E. | Excel Worksheet Functions | |||
Linear Mode
