How To Add Numbers Having Beginning And Ending Trailing Space

[amar.kshirsagar]

Hi All,

I have numeric data with beginning space, also the format of same is not calculating sum. (If beginning space removed manfully still it will not show as number style / format)

Right now I using formula =SUBSTITUTE (target cell,CHAR(160)," ")+0 , if there is any code to this work easier.

The sample of same is attached herewith for your reference

Thanks in advance

Regards

Amar K

[Excel Fox]

Use this =SUMPRODUCT(--SUBSTITUTE(B2:B40,CHAR(160),0))

[amar.kshirsagar]

Thanks Sir,

Thanks for your prompt reply, formula are working perfect.

But interval of I received files at my end is very high, so it will very help full to me to run by any codes.

Thanks for your valuable information and knowledge sharing

Regards

Amar K