Hi. I'm trying to simply copy a list of names from column A then paste them
into column B but when the names appear in column B they are surrounded by
square brackets []. I'm fairly new to Excel so please forgive me if this is a
stupidly simple thing to do!

Any help would be much appreciated.

Many thanks