[SOLVED] Join strings which are in a colum

Issue

Anyone can help on below pls.

Here is case

I have a column with hostnames Say :

Host1
Host2
..
..

I need to set bigpanda maintenance plan

host = host1* OR host2* OR ....

Solution

If you are looking for Excel solution then could try TEXTJOIN().

=TEXTJOIN("* OR ",1,A1:A13)&"* OR"

Answered By - Harun24hr

Answer Checked By - Katrina (WPSolving Volunteer)