Combining columns

androdriguez65476

Hi!

I'm trying to use the combined formula, but every time the 1st and 2nd columns are empty, the 3rd column brings the value with a 0 at the beginning.

Thank you in advance for your help.

Mark Cronk

Hi @androdriguez65476 ,

Try:

=Join(Collect([1st column]:[last column], ISTEXT(@Cell)),"-")

Where [1st colum ] is the name of the left most column and [last column] is the right most.

It should return the contents of each cell with text separated by a "-".

Work?

Mark