Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-06-2021, 08:16 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

Ok, nevermind, I found the solution myself.



For those interested, once I remove space for all 4 digit numbers, the numbers of 1 000 000 or more look like this: 1000 000. Then I did a Find/replace using wildcards. I did enter:

([0-9]{1})([0-9]{3}) ([0-9]{3})

Note there is a space before the last sequence.

In the Replace with: I did enter

\1 \2 \3

So 1000 000 becomes 1 000 000. Exactly what I was looking for.

Cheers.
Reply With Quote
Reply



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 02:24 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