Extract a NUmber from a string of Text

  • Thread starter Thread starter marcella63
  • Start date Start date
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.
 
Back
Top