Extract a NUmber from a string of Text

M

marcella63

Dear Experts:

I would like to extract a number from multi-line excel cells. The
cells have the following make-up

SELLING & MARKETING EXPENSES:MARKETING:Other Marketing:6019 · Travel:6019.15
· Hotel
SELLING & MARKETING EXPENSES:Brand Development:6100 · Brand Development
Labor:6100.01 · Brand Development Salaries
SELLING & MARKETING EXPENSES:Brand Development:6100 · Brand Development
Labor:Burden:6100.04 · Social Securitiy/MED
SELLING & MARKETING EXPENSES:Brand Development:6100 · Brand Development
Labor:Burden:6100.05 · FUTA/SUI Expense


In the above example I would like to extract the number located
to the far right. Can this be done using a formula/function?

Help is much appreciated. Thank you very much in advance.

Regards, Marcella.
 

My Computer

E

eBob.com

It looks like what regular expressions are intended for.

Bob

"marcella63" <[email protected]> wrote in message
news:[email protected]

> Dear Experts:
>
> I would like to extract a number from multi-line excel cells. The
> cells have the following make-up
>
> SELLING & MARKETING EXPENSES:MARKETING:Other Marketing:6019 ·
> Travel:6019.15
> · Hotel
> SELLING & MARKETING EXPENSES:Brand Development:6100 · Brand Development
> Labor:6100.01 · Brand Development Salaries
> SELLING & MARKETING EXPENSES:Brand Development:6100 · Brand Development
> Labor:Burden:6100.04 · Social Securitiy/MED
> SELLING & MARKETING EXPENSES:Brand Development:6100 · Brand Development
> Labor:Burden:6100.05 · FUTA/SUI Expense
>
>
> In the above example I would like to extract the number located
> to the far right. Can this be done using a formula/function?
>
> Help is much appreciated. Thank you very much in advance.
>
> Regards, Marcella.
>
>
 

My Computer

Top