Add numbers in one cell

B

Benoit

Hello,

In cell A1 I have the following

#12345 (100.00$); #23456 (250.00$); #34567 (500.00$)

In cell B1, I would like to have the total amount of the numbers between
brackets...

Is that possible???
 

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

Can someone explain how to make a sorted list with mail merge? 0
Excel does not accept text format! 0
Movve data from rows to columns 6
VBA Coding Help for Beginner 0
compare copied number with another fixed number. 4
Multi-demensional frequency distribution 4
Query results 3
Finding the proper style field and the numbered paragraph value within the style 0

Top