W
W
weranda2018-08-24 10:00:11
excel
weranda, 2018-08-24 10:00:11

How to search in excel using regular expressions?

Greetings
In the excel file, there are cells with numbers written with a hyphen:

1-1
22-33
500-100
30-120

Is it possible to search and highlight such cells in excel itself? If possible, please tell me how.

Answer the question

In order to leave comments, you need to log in

1 answer(s)
E
Exteris, 2018-08-27
@Exteris

If the task is set exactly as voiced, then regular expressions are not needed for this. Read about conditional formatting in Excel.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question