| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Extracting numbers from text
with thanks from Bob,Rick,Ron and suleman ; I think my last question was not
complete. let me ask it clearly as below: cell include reply cell include formula __ _________________________ ____ ___ ________ _____ A1 MR FRANK (25687) ----- B1 25687 ? A2 MR FRANK 256875787 ----- B2 256875787 ? A3 MR FRANK (256875) AT2008/2/6 ----- B3 256875 ? A4 MR FRANK 2560 IN U.S ----- B4 2560 ? A5 81602MR FRANK ----- B5 81602 ? would you please write for me the correct formula in cells B1 to B5 to achieve the reply just like above. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Extracting a numbers from a text string | Excel Worksheet Functions | |||
| Extracting numbers from string of text | Excel Discussion (Misc queries) | |||
| Extracting numbers from a text | Excel Discussion (Misc queries) | |||
| EXTRACTING NUMBERS FROM A TEXT CELL | New Users to Excel | |||
| extracting numbers from variable text | Excel Discussion (Misc queries) | |||
Threaded Mode
