Remove Blank Space

sambit · Dec 9, 2014

Hi,
how to remove blank space. pl find attached file.

Khalid NGO · Dec 9, 2014

Hi Sambit,
Try:
=SUBSTITUTE(M10,CHAR(160),"")+SUBSTITUTE(M11,CHAR(160),"")

Ratan Bhushan · Dec 9, 2014

sambit said:
Hi,
how to remove blank space. pl find attached file.

Use below function

=VALUE(RIGHT(M11,LEN(M11)-10))

sambit · Dec 9, 2014

Hi Khalid/Ratan,
Both formula working fine.

Thank you very much.

Somendra Misra · Dec 9, 2014

Hi,

Try in M12:

=SUBSTITUTE(M10,CHAR(160),"")+SUBSTITUTE(M11,CHAR(160),"")

Regards,

sambit · Dec 9, 2014

Somendra Sir,
Thanks.