Evagrius Ponticus
Well-known Member
- Joined
- May 24, 2007
- Messages
- 1,467
Hi all,
I have a column, column E, with data. Each cell in the column looks like this:
21 - 8%
5 - 21%
17 - 3%
and so forth. I am trying to add the number to the left of each cell. In my example here, I must sum 21+5+17 =
I thought I had it with this CSE but it didn't work. Thanks for any help with this.
I have a column, column E, with data. Each cell in the column looks like this:
21 - 8%
5 - 21%
17 - 3%
and so forth. I am trying to add the number to the left of each cell. In my example here, I must sum 21+5+17 =
I thought I had it with this CSE but it didn't work. Thanks for any help with this.
Code:
=SUM(VALUE(LEFT(E4:E16,FIND(" ",E4:E16,1))))
