Hello!

I've just received a spreadsheet that has in it cells containing both
percents and text (along with some other numbers) in the same cell. We need
to sum just the percentages.

Ex:
A1 contains 3.12% [Alt+Enter] at 122 days
B1 contains 4.56% [Alt+Enter] at 36 days
, etc.

I need a formula that will just add the percentages from those cells.

Any ideas?

Thanks,
Elf