Concatenate two columns

Hi Community,
As per image, I was wondering how I might be able to concatenate F an G columns into a final col H?
Thanks in advance for any guidance,

1 Like

How about =HYPERLINK(F3&G3)?. The image will not open in Calc but in your browser on Ctrl+Click.

1 Like

If content in F column is the same for all rows (as in the screenshot), and 3 is the first row with content, you can enter =F$3&G3 at H3, then fill it down (drag down the fill box, the little black square at the bottom right of the actual cell).
This will return only text (not an hyperlink).

Edit: No need to repeat F3 content in the cells below.

2 Likes

Thanks very much, solution works perfectly.(no hyperlink was required)