Hi elfmajesty

Is there any structured format to the data? Are all of the percentages x.xx,
or are some xx.xx or x.xxx?
It may be worth trying Data/Text to Columns. If you set the first option to
delimited and have a look at the result in the second dialog box, it may do.
Make sure you backup your data before you start playing, though!

Andy.

"elfmajesty" wrote in message
...
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