Forum Discussion
Ampersand creating extra space when last, first and middle intitial is combined.
I am connecting employee id numbers when I copy and paste data from programs at work. I had to use ampersand to conform to the data I pulled from to get the id numbers. This worked for all the driv...
Hello,
it would be helpful if you could post your formula and a data sample and specify what the desired result should be.
In the screenshot below, this is the formula
=TRIM(IF(LEN([@first])>0,[@first],"")&IF(LEN([@middle])>0," "&[@middle],"")&IF(LEN([@last])>0," "&[@last],""))
It does not duplicate blanks and leaves no leading or trailing blanks.
If you don't use a table with structured references, you can of course replace the column names with A2, B2 and C2, etc. then copy down.
Does that help?
how do you upload files?