Hi team,
Just discovered JOIN formaula - very helpful!
However, I can't seem to get it to join THREE coloumns together.
I'm using this formaula for joining two which is working perfect:
=JOIN([Quantity (m3)]1:[Time required]1, "-")
However, when I try and add in another (so a third coloumn) it errors.
=JOIN([Quantity (m3)]1:[Time required]1:[Boral O/N]1, "-") I get #UNPARSEABLE
Can it not deal with a third???? If not, are there any other solutions?
Thanks guys!
kylie