Copy Clipboard to Excel 2016

[amerifax]

Is there a way to do a simple copy and paste into Excel 2016?
My clipboard data is an address in column format, 5 rows.

I'm trying to start off very simple. My Excels 2016 is open. My cursor will be in the Excel location, cell, where I want my data placed. I want it placed in a role. As simple as it sounds I do need help.
Bob

ClipBoard
bob
phone
city
state
lat lon

In Excel 2016 I need a Row of 5 cells hyphens for display only
Bob - Phone - city - state - Lat lon

 

[Ranman256]

Start a macro,
Record the steps you need done.
Stop the macro.
Look at the macro code.
Adjust as needed.

 

[sneuberg]

If you want to paste a selection that was copied in a column to a row try this.

1. Copy the cells in column to the clipboard
2. Right click on the cell where you want the data to start
3. In the Paste Options click the forth option which is transpose