Excel insert cell value within string

Question

I have this formula:

=GetElementByRegex(H2,"<a href=""/testpage/Field/Index/15"">([^""]*?)</a>")

and I would like to replace 15 with a cell value e.g. J2 but i don't seem to figure it out how to add this correctly into the string.

Would appriciate help, thanks!

Wiktor Stribiżew · Accepted Answer · 2018-06-15 20:51:11Z

1

You may use

"<a href=""/testpage/Field/Index/" & J2 & """>([^<]*)</a>"

instead of "<a href=""/testpage/Field/Index/15"">([^""]*?)</a>".

Probably you also want to replace ([^""]*?) with ([^<]*) as [^<]* matches 0+ chars other than <.

answered Jun 15, 2018 at 20:51

Wiktor Stribiżew

631k41 gold badges502 silver badges633 bronze badges

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

1 Answer 1