Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Extracting a number from a string and converting it into an Intege
Hi
I have a text string from which I would like to extract a particular value, that is the number at the end, and then convert it into an integer value. The String is; Total item(s) found: 1 From which I want to be able to take the number at the end and convert it into an integer. Can anyone please assist in formulating a solution for doing that. Thanks Sumeet |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
converting a string of information into excel cells | Excel Worksheet Functions | |||
Converting text string to a its proper time format | Excel Discussion (Misc queries) | |||
converting number string to number with decimal | Excel Worksheet Functions | |||
Converting string of info in one cell into multiple | Excel Discussion (Misc queries) |