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