Forum Discussion

BerjoWeldDesignAB11's avatar
BerjoWeldDesignAB11
Copper Contributor
May 10, 2026
Solved

how to remove a blank in an imported text (wants number)

hi does anyone know how to change the imported text in left column 20:00 - 20:15             1 359,48     20:15 - 20:30             1 399,23     to number, where the...
excel
  • BerjoWeldDesignAB11's avatar
    BerjoWeldDesignAB11
    May 12, 2026

    thanks for your reply - however, it does not work. it seems that Excel wants something to put in place. I can replace the blank with a letter but not with "nothing":

     

Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
May 12, 2026

Select the column with the amounts looking like "1 359,48". Use 'Find & Replace' (Ctrl-H) to find a space and replace it with nothing.

BerjoWeldDesignAB11's avatar
BerjoWeldDesignAB11
Copper Contributor
May 12, 2026

thanks for your reply - however, it does not work. it seems that Excel wants something to put in place. I can replace the blank with a letter but not with "nothing":

 

  • BerjoWeldDesignAB11's avatar
    BerjoWeldDesignAB11
    Copper Contributor
    May 17, 2026

    hi

    l tried some different versions and solved it using:  

    =IF(S4>999;REPLACE(S4;2;1;);S4)

    so I used REPLACE on position 2 IF the number was > 999

    Thanks for the help !