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...
Ehhmmm, you posted a workbook with 8 sheets. It would be great if you could post some information about where the problem is.
Ideally, a data sample consists of the original data, a mock up of the desired results, and then some words that explain the logic for the expected result.
Can you explain or mock up what you would like to achieve in the context of your workbook, and use sheet names and cell addresses to help me find my way around your file?
do you still need help?