Forum Discussion
search and replace form "." to ","
Hello I'm a new one in this community. My problem is that I want to do "search and replace" from "." to "," I have a database of about 360,000 personal records in one file. In my new file I use as...
Does this do the trick you're looking for?
=SUBSTITUTE(B3,".",",",LEN(B3)-LEN(SUBSTITUTE(B3,".","")))
ChrisMendoza , that's the text like
Froek Zwarthoed(name) 38.97 1.18.06 1.59.56 4.18.74 7.24.47 15.38.88
in one cell
Oh, that's interesting if it's all in one cell. Ivo1954 you could use Power Query split by delimiter " " (space) then do a similar substitution on the last "." then concatenate the values again.
Yes, that's the task for Power Query or VBA. I didn't play with Power Query so far, but the solution looks not straightforward - variable number of columns, find and replace last dot in all columns at once. Perhaps Text.Split and List.Transform will be more suitable. Also, will it be any dot or number within the name on first position.
In any case some coding, not UI only.
