Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 10-05-2021, 11:41 AM
lalywizz lalywizz is offline Find/replace - remove a space in 4 digit numbers Windows 10 Find/replace - remove a space in 4 digit numbers Office 2016
Novice
Find/replace - remove a space in 4 digit numbers
 
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
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Find and Replace and add colon and space falcios Word 2 07-28-2021 04:38 AM
Find/replace - remove a space in 4 digit numbers Using find and replace to insert an extra space after full stops Johanna Word 33 03-07-2020 01:43 PM
Macro for Find/replace to remove space before Hard Return AlfredStreich Word VBA 4 01-23-2020 03:59 PM
Find/replace - remove a space in 4 digit numbers Find and Replace with space cheech1981 Word 3 03-29-2017 02:33 PM
Find/replace - remove a space in 4 digit numbers remove color from find/replace? Cobb78 Word 1 05-26-2012 06:16 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:21 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft