Spreadsheet question

[spionfox]

I have two columns of data. I want to select all of the data and then paste the contents of the two columns into just one column but with 'space hyphen space' in-between the two sets of data.

Anyone know a simple way of achieving this? Thanks.

 

[Jeff]

This is based on the version of Excel I currently use (2003) - assuming your data is in columns A and B.

In a new column, add the following:

=A1&" - "&B1

That should then have a new column with the layout you require. As it's a formula, you may then want to change it to just the values. You can do this by selecting the column, copying it, then using one of the paste options to just paste the values rather than the formula. Can't remember the exact wording of that option.

 

[spionfox]

This is based on the version of Excel I currently use (2003) - assuming your data is in columns A and B.

In a new column, add the following:

=A1&" - "&B1

That should then have a new column with the layout you require. As it's a formula, you may then want to change it to just the values. You can do this by selecting the column, copying it, then using one of the paste options to just paste the values rather than the formula. Can't remember the exact wording of that option.

Cheers Jeff - your guidance helped me to the following:

=CONCATENATE(A1," - ",B1)

If you weren't already a legend you are now because you have just helped me to easily make my own 'recently played' playlist data so that I can resume posting in the 'What are you listening to now' thread.

Blaarev, Mawsley et al will be delighted with you - cheers :icon_bigg

 

[fox58]

It was a trick question

 

[Jeff]

****. Bollocks. Shit.

 

[pork pie fox]

Schooled by Spion.

 

[spionfox]

It was a trick question

:icon_bigg

****. Bollocks. Shit.

Schooled by Spion.

 

[jb5000]

Maybe save as a comna separated values file (. Csv), open in word pad and find replace all commas for hyphens. This would be incredibly easy in Linux!

 

[bocadillo]

****. Bollocks. Shit.

Jef Fout