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

Question

hidoes anyone know how to change the imported text in left column20:00 - 20:15&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;1&nbsp;359,48&nbsp;&nbsp;20:15 - 20:30&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;1&nbsp;399,23&nbsp;&nbsp;to number, where the blank is removed ?

riny_van_eekelen · Answer

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

Forum Discussion

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

1 Reply

20:00 - 20:15							1 359,48
20:15 - 20:30							1 399,23