Forum Discussion
Ampersand creating extra space when last, first and middle intitial is combined.
I used the example you gave and most of the id numbers pop up but the same two will not. I was able to get them by manuelly adding a space at the end of the name. Very frustrated. I am also having issues with the multiple names. Need to pull all employee engine checks, post-trips, swipes, student checks into form. However, vlook up only does the first duplicate and skips the rest.
Hello,
where does Vlookup come in? Your question is about combining first, middle and last name without any extra spaces. Are you then using the result of the concatenation in a Vlookup? Please post a data sample, but please make sure these are not real names. Make up some fake ones to protect people's privacy.
You can upload a file by clicking the button "Choose Files" that appears when you write a post or a reply.
Trying again....seems I am having issues because when I choose the file and send it does not go through.
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?