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 blank is removed ?

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":

     

3 Replies

  • 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 !