Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-13-2016, 03:11 PM
johnbrowny johnbrowny is offline Help with: Replace and reformat numbers inside square brackets Windows 10 Help with: Replace and reformat numbers inside square brackets Office 2016
Novice
Help with: Replace and reformat numbers inside square brackets
 
Join Date: Feb 2016
Posts: 1
johnbrowny is on a distinguished road
Default Help with: Replace and reformat numbers inside square brackets

I have a long document containing hundreds of numbers in square brackets that looks like this.



[399]

Some of them have two numbers separated by a comma which looks like this.

[123, 456] [234 - 678]

I would like to be able to find and change the colour of only the numbers within these square brackets only. So they will look like this.

[399] [123, 456] [234 - 678]



I found this online https://cybertext.wordpress.com/2011...ing-wildcards/


However it changes everything including the square brackets and commas. Resulting in this.

[399] [123, 456] [234 - 678]


Please help!
Reply With Quote
  #2  
Old 02-13-2016, 06:45 PM
macropod's Avatar
macropod macropod is offline Help with: Replace and reformat numbers inside square brackets Windows 7 64bit Help with: Replace and reformat numbers inside square brackets Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

You can do this with a wildcard Find/Replace, where:
Find = \[[0-9,\- –]{1,}\]
Replace = ^&
and the replacement parameters include the blue formatting.

Note that this will colour the brackets as well.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Help with: Replace and reformat numbers inside square brackets Search+replace all --- [3 dashes] with square wingding imported_contiw Word 14 10-04-2017 01:03 PM
Help with: Replace and reformat numbers inside square brackets Find and Replace - How to insert brackets around all numbers in a doc Natedogg Word 2 05-21-2015 07:16 AM
Gray square brackets waldux Word 8 09-25-2013 04:14 PM
Help with: Replace and reformat numbers inside square brackets square brackets and grey background – why? eNGiNe Word 2 11-21-2012 01:06 AM
Help with: Replace and reformat numbers inside square brackets Please help copy inside brackets Jana Word VBA 49 02-05-2012 02:41 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:39 PM.


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