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
Help Article Resources
Check out the Formula Handbook template!