| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Extract part of a cell
Hi,
My name is André Lopes and i am writing from Brazil. I have a big problem and i am nedding help ... I have in a cell (For example "A2") the following: "Este é um teste e a taxa do USD é USD - 1.667" And i need to extract only the value that will be, ever, *.***, where * means any number. Please note that i never know what will be the number of digits in the cell, being that the value could have digits after it too. |
| 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
