Once combined, you need to change the merged data to values using copy and paste so you can ... This tells excel you want to ...