Forum Discussion

karolina189's avatar
karolina189
Copper Contributor
Apr 24, 2022

Remove spaces in in list of numbers - numbers are not displayed correctly

I have to read an Excel file originating from a website into R-Studios (xml). There is a row with numbers where there is unnecessary space between some digits, like: 

8350 8380 8384 8385

 

I wanted to remove the spaces, using STRG + H. Then the numbers are displayed such as: 

8,35084E+15

I tried to replace them with the normal form, but then the numbers are displaced incorrectly with a 0 at the end. How do I adress this problem so that all numbers are shown as (example): 

8350838083848385

Resources