Phantom Gourmet?
Fri, 07/24/2009 - 10:04pm
 |
   15 years
|
I haven't found a POI for Phantom Gourmet, so I'm trying to create one. On their webpage (phantomgourmet.com) I do a search without restrictions and get a great table - but I can't seem to pull the info into a suitable form for excel. I can select all and copy into excel, but there's some wackiness about the formatting...and I'm not savvy enough with excel to straighten it out...yet...
Any tips would be very helpful. Thanks.
Paste special
I haven't found a POI for Phantom Gourmet, so I'm trying to create one. On their webpage (phantomgourmet.com) I do a search without restrictions and get a great table - but I can't seem to pull the info into a suitable form for excel. I can select all and copy into excel, but there's some wackiness about the formatting...and I'm not savvy enough with excel to straighten it out...yet...
Any tips would be very helpful. Thanks.
Once you highlight the data and copy, go to your spreadsheet and do a Paste/Special/Text. This will convert the html text to standard ASCII characters. From there you can manipulate it using standard commands.
ɐ‾nsǝɹ Just one click away from the end of the Internet
thanks, but it's more complex....
Appreciate the comment, thanks. I'm familiar with the past special option(s). However, the table appears more complicated in that certain cells are merged - but not consistently, so I may need to manually massage the data and tnen use other excel functions such as concatenate, substitute, etc...to generate new columns. I'll keep poking at it!
non-native nutmegger