paste question

P

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
 
V

VBA Noob

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

VBA Noob
 
D

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)
 
P

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!
 
G

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
 
D

Dave Peterson

Well, that's better than my first thought.

But this is a family newsgroup <bg>.
 
Top