Join and Left Formulas
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
Best Answer

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 :)
Answers

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 :)

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)

Happy to help :)
Help Article Resources
Categories
Check out the Formula Handbook template!