m2 behinde a number and I want to sum
in [Charts]
|
Prev: SOS! how do I write a customized function to do multiple-value lookupin Excel 2007?
Next: How to change series plotting order without changing legend order?
From: sas on 1 Dec 2009 06:01 5 m² 3 m² 7 m² 2 m² 2m² 12m² How can I get the sum without clearing the m2 in the field?
From: Bernard Liengme on 1 Dec 2009 09:08 Let's say the first on in in A1 Insert a new column B In B1 enter =--LEFT(A1,LEN(A1)-3); this will retunr the number 5 (if you have 5 m� in A1) Copy down the column and add Now you have real numbers that can be added For a permanent solution: after you have done the above Select all the new B values and give them the custom format: 0 "m�" Select all the B values and Copy, with them still selected use Edit | Paste Special -> Values to turn the formulas to numbers Now you have real numbers that can be added Now you can delete column A best wishes -- Bernard Liengme http://people.stfx.ca/bliengme Microsoft Excel MVP "sas" <siggiandri(a)gmail.com> wrote in message news:f19629db-6f3d-4b94-b63e-88f1a41f9e4f(a)d10g2000yqh.googlegroups.com... > 5 m� > 3 m� > 7 m� > 2 m� > 2m� > 12m� > How can I get the sum without clearing the m2 in the field?
From: Luke M on 1 Dec 2009 09:29
You need to first create a helper column to strip out the number. Something like: =VALUE(LEFT(A1,FIND(" ",A1)-1)) And then perform a summation of the helper column. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "sas" wrote: > 5 m² > 3 m² > 7 m² > 2 m² > 2m² > 12m² > How can I get the sum without clearing the m2 in the field? > . > |