Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
,I'm using Outlook 2003.
I have a column containing free-format text values. (Example: "HNSMUPP requested authority of ICIEMERG for reason HNSMUPP ICIEMERG 1026382 - RST OF GUS, CMC FROM AFTSAVE. 03/07/09 06:51 QPGMR I5IPRD2A"). I need to find and extract the 7-digit numeric value (in this example: 1026382) into another cell. Any suggestions? Can this be done with Excel built-in functions? Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Format part of text in concatenated field | Excel Worksheet Functions | |||
Find and Add a number in a text field | Excel Worksheet Functions | |||
Copying text from a free form field | Excel Worksheet Functions | |||
ddd format to 'text' field | Excel Discussion (Misc queries) | |||
Everytime I need to format cells or text, Excel 2003 takes a lot of time or free | Excel Discussion (Misc queries) |