Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi,
with thanks from Bob,Rick,Ron and Suleman , I think I did not ask my question clearly . let I write it again as an example : cell include reply cell including 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 25602MR FRANK -- B5 25602 ? please send for me the correct formulas that I shoude use in the cells from B1 to B5 till I can get the above replies. thank you, |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Separating Text From Numbers | Excel Discussion (Misc queries) | |||
separating numbers from a alphanumeric cell | Excel Worksheet Functions | |||
separating +ve and -ve numbers into two columns | Excel Discussion (Misc queries) | |||
Help - Separating numbers appearing on the right of a text string | Excel Worksheet Functions | |||
Separating Numbers | Excel Worksheet Functions |