Hi,

I have something that looks like this (it's from a list of airports);

1,"Goroka","Goroka","Papua New Guinea","GKA","AYGA",-6.081689,145.391881,5282,10,"U"

I want to show some of the content in the adjacent cell so it looks like this;

Goroka (GKA), Garoka, Papua New Guinea

And I want to be able to copy the the above into a dropdown (rather than the formula that created it).

How do I do this?

Many thanks,
Dom