Showing Values on Angle:

here is chart to show value on Angle Suppose you have data like below table : Angle Strength 45 40 90 60 135 50 180 90 225 45 270 55 300 65 315 60 360 80 Here is a trick to show This data on chart, Here is xlsx file Thanks Rajan

Array Formula ( Extract only Numeric from a string)

Here is a Array formula where A1 has alphanumeric value =SUM(INT(MID(A1,LARGE(–ISNUMBER(INT(MID(A1,ROW(INDIRECT(“1:”&LEN(A1))),1)))*ROW(INDIRECT(“1:”&LEN(A1))),ROW(INDIRECT(“1:”&SUM(–ISNUMBER(INT(MID(A1,ROW(INDIRECT(“1:”&LEN(A1))),1))))))),1)*10^ROW(INDIRECT(“1:”&SUM(–ISNUMBER(INT(MID(A1,ROW(INDIRECT(“1:”&LEN(A1))),1))))))))/10 Please share your idea to do the same.