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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Extracting a number from a multiline-entry 9
Extract a number from a variable text string 4
Extract only part of a string 6
Formula to extract a phone# from a cell of text (eg classified)? 3
Extract Only Number From A String 3
Extract a number from a cell of text 1
i need help creating a function that will extract words from a string of text 4
How To Get 1 Million Visitors Without Paying A Dime In Advertising 0

Top