Join and Left Formulas

Charlene Stacy

I am trying to Join three columns, the first two are full names the third is a auto generated number. I need the first letter of each column and then the number. I've tried to use Join and Left but it is not working for me, the Join work or the Left works, but combining them is not working.

The N Section below is the result I want to achieve and it needs to be a column formula. Thx

Mike matthys

what about something like this ?

=LEFT(University@row; 1) + LEFT(Location@row; 1) + "-" + [Course Number]@row

or make 2 helpers

UniHelper

=LEFT(University@row; 1)

LocHelper

=LEFT(Location@row; 1)

and for your output field

=JOIN(UniHelper@row:LocHelper@row; "") + "-" + [Course Number]@row

then hide the helpers :)

maybe there is a more compact way but thats how i do it atm till i get more knowledge :)

hope it helps :)

Mike matthys

what about something like this ?

=LEFT(University@row; 1) + LEFT(Location@row; 1) + "-" + [Course Number]@row

or make 2 helpers

UniHelper

=LEFT(University@row; 1)

LocHelper

=LEFT(Location@row; 1)

and for your output field

=JOIN(UniHelper@row:LocHelper@row; "") + "-" + [Course Number]@row

then hide the helpers :)

maybe there is a more compact way but thats how i do it atm till i get more knowledge :)

hope it helps :)

Charlene Stacy

As always the community has helped me find or rethink a different approach. This worked, thank you.

=JOIN(LEFT(University@row, 1) + "" + LEFT([Location/Site]@row, 1) + "-" + [Course Number]@row)

Mike matthys

Happy to help :)