Moving comma inside text

[M_Timps]

Hello! I have this problem for which I have been searching a solution for some time now. This may be due to lack of knowledge in Excel or poor skill of the English language. I need the first column to look like the second column - simply move the comma by one number to the left. Help would be much appreciated.

15,23	1,52
146,32	14,63
7,85	0,78

<tbody>
</tbody>

 

[aaronbens]

Try this:
=CONCATENATE(LEFT(B1,FIND(",",B1)-1),MID(B1,FIND(",",B1)+1,1),",",RIGHT(B1,LEN(B1)-(FIND(",",B1))-1))

 

[Anthony47]

In addition to what suggested by aaronbens, above:
If the initial string is in A2:

=IFERROR(TEXT(SUBSTITUTE(A2,".",",")/10,"0.00");"")

Bye

 

[M_Timps]

Thanks for the answers. Tried both suggestions but got an error in the formulae - probably because lack of skill. I figured out a another solution though. I simply divided the whole column with 10 and it work for me.