| Home |
| Search |
| Today's Posts |
|
#15
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Extract part of a cell
On Sat, 8 Nov 2008 17:23:01 -0500, "Rick Rothstein"
wrote: To the OP: This formula would need the double unary in front of it if the extracted value is to be a number and not text... =--LEFT(TRIM(MID(A1,FIND("-",A1)+1,99))&" ", FIND(" ",TRIM(MID(A1,FIND("-",A1)+1,99))&" ")-1) -- Rick (MVP - Excel) Again, to the OP: Be aware that the double unary will only work properly for you if the number in your text string is formatted the same as is expected on your Windows Regional Settings (in Control Panel). The US uses the dot as a decimal symbol; and the comma as a digit grouping symbol. In Portuguese these are reversed. --ron |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Extract numeric part of alphanumeric cell | Excel Worksheet Functions | |||
| Is there a function to extract the URL part of a hyperlink in another cell? | Excel Worksheet Functions | |||
| Can I search a cell for a value and extract part of content? | Excel Discussion (Misc queries) | |||
| Extract Part of String | Excel Worksheet Functions | |||
| vlookup to extract part cell content | Excel Discussion (Misc queries) | |||
Threaded Mode
