How to keep Hyperlinks in Concatenate function inline with surrounding text?

1

Hi,

I’m trying to concatenating several column values and one of them is a Hyperlink, however it is breaking the line as it were a block element instead of an inline one, see below:

If I don’t use the Hyperlink formula, it keeps all text together:

Capturar-1
Capturar-1794×557 36 KB

If I use the Hyperlink formula, the link “jumps” to the next line and the same happens with the text concatenated after it:

Capturar
Capturar799×583 36.4 KB

Does anyone know how to avoid this behavior?

2

Yeah, this is annoying.

Usually I just tend to avoid long hyperlinks and e.g. include a single character hyperlink (↗) in the end of the text. But if I wanted to hyperlink the whole title like you did, I’d probably go ahead and do the vile thing of splitting the title down into words and making each word a separate hyperlink:

...
Title.Split(" ").ForEach(
  Hyperlink([Full Text], CurrentValue).Concatenate(" ")
).Concatenate().Slice(1, -2)
...

(not just Join(" ") because Join ruins rich formatting and removes hyperlinks; therefore concatenate with spaces and then cut away the trailing space)

1 Like
3

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.