Hello everyone,
I'm having trouble combining two names in MS Excel and was wondering if anyone could help me out. I have a list of names in two separate columns and I want to combine them into one column. How can I do that?
I've tried using the CONCATENATE function, but it only works if the names are in the same column. I've also tried using the "&" symbol, but that only combines the names without a space in between.
Does anyone know of a way to combine two names with a space in between in MS Excel? Any suggestions would be greatly appreciated!
Thank you in advance.