Using replace with regular expressions - VBA

Question

I would like to format a text. I mean something like this: I'd like to transform this:

"something'text between apostrophes'text"

into

"something 'text between apostrophes' text"

I want to add spaces from both sides, but keep te string in '' the same. I tried to do it like this:

  Arkusz1.Cells(1, 1).Replace What:="'*'" Replacement:=" '*' "

But its result is:

"something '*' text"

Arkusz1.Cells(1,1) contains the string I want to replace. Is it possible to do this? Thanks

Mustofa Rizwan · Accepted Answer · 2020-07-14 08:33:40Z

2

You can try this regex:

('[^']+')

and replace by this:

" $1 "

answered Oct 12, 2017 at 6:13

Mustofa Rizwan

10.5k2 gold badges30 silver badges46 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

The OP is about VBA, not VB.NET.