How the heck do I do this in Excel?

[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