Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
extract number
Hi
I wondered if anyone knew the formula to extract a block of numbers in amongst a sentace, the numbers are a a different place in each line (mr joe bloggs 12456 mrs smith hometown county 75864 mr tom jones county potcode 44456) the numbers always contain 6 digits. Thank you!! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
extract number from alphanumric | Excel Worksheet Functions | |||
Extract the row number | Excel Worksheet Functions | |||
extract number | Excel Discussion (Misc queries) | |||
Extract number from text/number string.. | Excel Discussion (Misc queries) | |||
How to extract the Number from a String | New Users to Excel |