View Single Post
 
Old 10-05-2021, 11:41 AM
lalywizz lalywizz is offline Windows 10 Office 2016
Novice
 
Join Date: Sep 2021
Posts: 7
lalywizz is on a distinguished road
Default Find/replace - remove a space in 4 digit numbers

Hi there. In my text, I would like to remove the space for every 4 digits numbers (ex. 2 000 becomes 2000). However, I also have numbers of 1 000 000 or more in this text which thousands are separated by spaces. And by removing the spaces for every 4 digits numbers, I don't want it to affect the numbers of 1 000 000 or more (i.e. I don't want the number "1 000 000" to become "1000 000" because of this change).

I'm looking for a way to do a find/replace (using wildcards) so that 4 digit numbers don't contain a space, but for numbers 1 000 000 and above, the space remains present.

Any suggestion? Thanks.

Last edited by lalywizz; 10-06-2021 at 06:28 AM.
Reply With Quote