How the heck do I do this in Excel?

LloydA111

I'm trying to paste some values into a sheet. These are my values:

1:11 9.812
1:21 10.0
1:31 9.937
1:41 9.875
1:51 9.875
2:1 9.937
2:11 9.75

Theres a space separating the values yet when I paste it into Excel it puts everything into one column. I'm trying to make it paste the values on the left into one column and the values on the right of the space into the column next to it. I'm sure I've done this before with no problem. Any clues?! :)

       .-.
      |o,o|
   ,| \_\\=/\_      .-""-.
   ||/\_/\_\\\_\\    /\[\] \_ \_\\
   |\_/|(\_)|\\\\  \_|\_o\_LII|\_
      \\.\_./// / | ==== | \\
      |\\\_/|"\` |\_| ==== |\_|
      |\_|\_|    ||" ||  ||
      |-|-|    ||LI  o ||
      |\_|\_|    ||'----'||
     /\_/ \\\_\\  /\_\_|    |\_\_\\

Brisingr Aerowing

This?[^] Or this?[^]

Gryphons Are Awesome! ‮Gryphons Are Awesome!‬

AspDotNetDev

Convert the spaces to tabs before pasting?

Thou mewling ill-breeding pignut!

LloydA111

Didn't think of that... It's 4.30 AM afterall :^) *brain fart*

       .-.
      |o,o|
   ,| \_\\=/\_      .-""-.
   ||/\_/\_\\\_\\    /\[\] \_ \_\\
   |\_/|(\_)|\\\\  \_|\_o\_LII|\_
      \\.\_./// / | ==== | \\
      |\\\_/|"\` |\_| ==== |\_|
      |\_|\_|    ||" ||  ||
      |-|-|    ||LI  o ||
      |\_|\_|    ||'----'||
     /\_/ \\\_\\  /\_\_|    |\_\_\\

AlphaDeltaTheta

AspDotNetDev wrote:

Convert the spaces to tabs before pasting?

Tab separated values... why not comma separated????

AspDotNetDev

Why not interrobang separated‽‽‽‽‽‽‽‽‽‽‽‽‽‽‽‽‽‽‽‽‽‽‽‽‽‽‽‽‽‽‽‽‽‽‽‽‽‽‽‽‽‽‽‽‽‽‽‽‽‽‽‽‽‽‽‽‽‽‽‽‽‽‽‽‽‽‽‽‽‽‽‽‽‽‽‽‽‽‽‽‽‽‽‽‽‽‽‽‽‽‽‽‽‽‽‽‽‽... ... ‽‽‽‽‽‽‽‽‽‽‽‽‽‽‽‽‽‽‽‽‽‽‽‽‽‽‽‽‽‽‽‽‽‽‽‽‽‽‽‽‽‽‽‽‽‽‽‽‽‽‽‽‽‽‽‽‽‽‽‽‽‽‽‽‽‽‽‽‽‽‽‽‽‽

Thou mewling ill-breeding pignut!

AlphaDeltaTheta

Did we have something like this... ISV => Introbang separated values? *AFAIK, ISV == Independent Software Vendor

OriginalGriff

Amitosh Swain wrote:

ISV == Independent Software Vendor

Nope: International Standard Version

The universe is composed of electrons, neutrons, protons and......morons. (ThePhantomUpvoter)

Marc Clifton

Save it as a text file, import it, and tell Excel the delimiter is a space (somewhere in one of the import wizard pages.) Marc

Testers Wanted!
Latest Article: User Authentication on Ruby on Rails - the definitive how to
My Blog

Jorgen Andersson

You should avoid Commas as separation character. Commas are quite generally used for many purposes, for example, most non anglicised countries use decimal comma rather than decimal point. There are plenty more places where commas are used while the tab is used for, wait for it, tabulation.

Be excellent to each other. And... PARTY ON, DUDES! Abraham Lincoln

Mark_Wallace

Lloyd Atkinson wrote:

Any clues?!

Why are the files called "**Tsv", rather than "S**sv"? Elementary, my dear Watson.

I wanna be a eunuchs developer! Pass me a bread knife!

Duke Carey

After you've pasted the values in to Excel, select the single column and, if you're using Excel 2007 or later, go to the Data tab and choose Text to columns. If using pre-2007 Excel, use the Data menu. Can't remember the menu choices, but the key stroke shortcut is Alt-D, E, so it may be Data->Text to columns there, too. That'll start a wizard which will allow you to split the data based on Fixed length or Delimited, and therein you can choose the space, a comma, a Tab, or some other delimiter

Dan Neely

The Rube Goldberg solution: Convert it to an HTML table, open it in IE, and copy/paste from there. Pasting tabular data into Excel is one of the very few things IE does better than the competition.

Did you ever see history portrayed as an old man with a wise brow and pulseless heart, waging all things in the balance of reason? Is not rather the genius of history like an eternal, imploring maiden, full of fire, with a burning heart and flaming soul, humanly warm and humanly beautiful? --Zachris Topelius Training a telescope on one’s own belly button will only reveal lint. You like that? You go right on staring at it. I prefer looking at galaxies. -- Sarah Hoyt