Replacing values in via wildcard...

kikola · #1 05-26-2020, 03:28 AM

Hello, I have the long text where words are incorrectly jointed with no spaces after "point".
I need to find .([a-h)]^13 and replace it with .space(point with space).

How is it possible??

Also I need find ?([a-h)]^13 and replace it with ?space(question mark with space).

Thanks, in advanced..

Charles Kenyon · #2 05-26-2020, 04:31 AM

Why "a-h" rather than "a-z?"

kikola · #3 05-26-2020, 05:35 AM

YEs, sorry a-z.

macropod · #4 05-26-2020, 05:44 AM

You could use a wildcard Find/Replace, where:
Find= ([a-z0-9][.\!\?])([A-Z])
Replace = \1 \2

kikola · #5 05-26-2020, 06:05 AM

Thanks, it is solved..

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Table with values from several locations and years - need to find comp values	Ricardo Sousa	Excel	9	07-27-2018 02:06 AM
Table with values from several locations and years - need to find comp values	Ricardo Sousa	Excel	6	06-09-2018 10:51 PM
Display multiple values as new values based on selection from template.	MvdB	Excel	2	09-29-2015 08:51 PM
Change characters outside a wildcard while keeping wildcard results	nymusicman	Word VBA	2	04-10-2014 08:17 AM
Replacing curly braces in a wildcard F&R	Ulodesk	Word	9	02-21-2014 07:28 AM