Using FIND to highlight text (with dashes)


Joined
Jun 12, 2019
Messages
3
Reaction score
0
Is there a way to use FIND to highlight all text that has a dash (hyphen) to the left or right of it?

Example of things I need to highlight:

2-11-3
4-7-1
19-20-4, 6-1-1
7-4-2

I don't know if there is a wildcard formula that lets me highlight all occurances of these. Maybe something that follows the logic of "Highlight all to the left or right of a hyphen, stopping at SPACE" or something like that?
 

macropod

Microsoft MVP
Joined
Mar 2, 2012
Messages
455
Reaction score
39
You could use a wildcard Find:
Find = [0-9]{1,}-
[0-9]{1,}-
[0-9]{1,}
 
Ad

Advertisements

Ad

Advertisements

macropod

Microsoft MVP
Joined
Mar 2, 2012
Messages
455
Reaction score
39
Somehow the forum software messed up my post -

Find = [0-9]{1,}-[0-9]{1,}-[0-9]{1,}
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top