Microsoft Office Forums - View Single Post - Replace dashes between two digits without using Selection

Thread: Replace dashes between two digits without using Selection

View Single Post

Old

09-28-2023, 01:48 PM

rollis13

rollis13 is offline

rollis13 uses Windows 11

Windows 11 rollis13 uses Office 2016

rollis13 uses Office 2016

Office 2016

Competent Performer

Join Date: Jan 2021

Location: Cordenons

Posts: 143

rollis13 will become famous soon enough

Default

With "^#" & Chr(150) & "^#" it only works if it finds a m-dash between two numbers (and no spaces in between); ^# is jolly for a number.

__________________
Difficult is not to know but to share what you know (Han Fei Tzu reworked)

Reply With Quote