| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Extracting a number from a multiline-entry
Dear Experts:
I would like to extract a number from multi-line excel cells. The cells have the following make-up 123456(manual line break = Alt+Enter) sample text (manual line break = Alt+Enter) sample text In the above example I would like to extract the number located immediately before the first manual line break and display it in a separate cell. Can this be done using a formula/function? Help is much appreciated. Thank you very much in advance. Regards, Andreas |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Text parsing - Extracting data from inconsistent data entry format. | Excel Programming | |||
| Multiline textbox for data entry | Excel Programming | |||
| Extracting first two digits of a time entry!! | Excel Programming | |||
| Help!!! Extracting a number to line up with a different number | Excel Discussion (Misc queries) | |||
| Extracting text from a cell entry | Excel Discussion (Misc queries) | |||
Threaded Mode
