Right Left function

[piresmdb]

hi
im trying to use the sustitution funnction and the right and left f to delete the points .... as the example below but im not get it
can someone help me please

Financial assets designated at fair value ............................................................ 16 15,467 16,435

 

[WinteE]

=SUBSTITUTE("Financial assets designated at fair value ............................................................ 16 15,467 16,435";".";"")

 

[ganeshpoojary05]

I guess this will work:

=SUBSTITUTE(A1,".","")