Forum Discussion
Remove a comma from a number treated as text
Greetings! I'm new to this forum, and I don't know if this is the right place to ask. But, here it goes: I have a column of currency values which is a mess. I managed to clean it as much as possib...
Try
=LET(n,TEXT(A1:A5,"#,00"),d,REGEXEXTRACTI(n,",\d{2}$"),BYROW(n&"§"&d,LAMBDA(r,SUBSTITUTE(SUBSTITUTE(TEXTBEFORE(r,"§"),TEXTAFTER(r,"§"),""),",","")&TEXTAFTER(r,"§"))))
Bye