paste question

[panni]

Hi,
this must be a stupid easy problem but I have trouble with it:
I want to paste data from a table from the web to an excel file but i
puts all the data in one column instead of 4 columns.
There must be a simple solution for this!
Please help me out!
Pann

 

[VBA Noob]

Depending on the format of the data e.g if seperated by a , you could
try text to Columns

VBA Noob

 

[panni]

well, o.k. but how do I do text to column?

 

[Dave Peterson]

Select the column
Data|Text to columns

follow the wizard
Maybe
delimited
by commas

And set your fields to what you want (general/date/text/skip)

 

[panni]

O.k., I found it but it didn't help.:confused

 

[VBA Noob]

Can you post the data. All show an example of the data ?

 

[panni]

I can't post it here.
But it really is nothing special.
If I copy it into a word document, it is separated by a "return". I can
change it all to tabs, then convert to table and then copy to excel but
it's quite a long process because there's just too much of it.
Anyway, thanks a lot for helping!

 

[Gord Dibben]

Using the Text to Columns Wizard, carriage returns are entered in the "Other"

box by holding the ALT key while typing 0010 on the NumPad keys.


Gord Dibben MS Excel MVP

 

[Dave Peterson]

Or use ctrl-j (instead of alt-0010 on the number pad)

<vbg>

 

[Gord Dibben]

I'm just a FOF

Gord

Or use ctrl-j (instead of alt-0010 on the number pad)

<vbg>

Gord Dibben MS Excel MVP

 

[Dave Peterson]

Friend of Frank?

or something old fart?

I'm just a FOF

Gord



Gord Dibben MS Excel MVP

 

[Gord Dibben]

You're two thirds of the way there<g>

Add forgetful.


Gord

Friend of Frank?

or something old fart?

Gord Dibben MS Excel MVP

 

[Dave Peterson]

Well, that's better than my first thought.

But this is a family newsgroup <bg>.