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)