Prev: XP Services Registry errors
Next: Final Reminder - Microsoft Responds to the Evolution of Community
From: marcella63 on 27 May 2010 17:43
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.


From: eBob.com on 28 May 2010 08:59
It looks like what regular expressions are intended for.

Bob

"marcella63" <marcella63(a)discussions.microsoft.com> wrote in message
news:B6C8050A-9295-4E90-BBFA-7DFD96AACC92(a)microsoft.com...
> 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.
>
>


 | 
Pages: 1
Prev: XP Services Registry errors
Next: Final Reminder - Microsoft Responds to the Evolution of Community