A
andreashermle
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
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