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

Thread Tools
Display Modes


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:08 PM.


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