Merging columns in Excel

[SourChipmunk]

I have a worksheet with 3 columns. I would like 1 column to contain all the data from those 3 columns merged together. I have tried the "Merge and Center" button, but it only retains the data in the left-most column.

To explain better, I was given a list of server names, along with a list of domains. I put another column between them with a "." so it should become an FQDN. Unfortunately if I try to just copy/paste this data into notepad it keeps the tabs between the columns.

Anyone know of a solution?

 

[SourChipmunk]

Thanks, aix0. I'll see if that works next time.

Interim solution: I exported the workbook to a comma delimited text file, then used notepad to replace the commas with nothing. Worked a charm.

 

[SourChipmunk]

You could add a fourth column and concatenate the data.

Aix0 is correct, use the concatenate function.

Gave it a try and Wow! Oh, so much Excel is capable of. That will be extremely handy for revisions. Thank you!