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.


[TABLE="class: grid, width: 300"]
<tbody>[TR]
[TD]15,23[/TD]
[TD]1,52[/TD]
[/TR]
[TR]
[TD]146,32[/TD]
[TD]14,63[/TD]
[/TR]
[TR]
[TD]7,85[/TD]
[TD]0,78[/TD]
[/TR]
</tbody>[/TABLE]

 

[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.