Para dividir texto en columnas,
ocupamos la opción con el mismo nombre. En primer lugar debemos colocar la
celda activa en el texto que queremos cortar. Al dar clic en la opción, nos
aparecerá el asistente para importar. La diferencia es que en el paso 3
nos pide especificar en qué columna irán las palabras que se han cortado.
Vamos a importar datos desde la web: http://www.mundoencolores.com/nacimiento_sopa.html. Aquí encontraremos...
![Limpieza Empresas en Rubi](<table width="782" border="0"> <tbody><tr> <th scope="col"><a href="http://www.blogger.com/rel=%22nofollow%22%22http://www.totalping.com/pin.totalping?idioma=ES&skin=6&bookmark=e00a25eb&name=AYUDA+EXCEL+2010&url=http://ayudaexcel2010.blogspot.com/&rss=http://feeds.feedburner.com/blogspot/NNfcG&ping=1&ser1=1-2-3-4-5-9-11-12-16-17-18-21-22-23-24-25-26-27-28-29-30-&ser2=1-4-5-8-9-10-11-14-15-16-17-18-19-20-21-22-23-24-26-27-28-29-30-31-32-33-34-&tipo=3&pagina=1%22" title="Mi Ping en TotalPing.com"><img border="0" src="http://i155.photobucket.com/albums/s282/theviejo/recurso_6_6.jpg" width="88" height="31" alt="Mi Ping en TotalPing.com" /></a></th> <th scope="col"><a rel="nofollow" href="http://www.blogrankings.com/finance/"><img style="border:none" src="http://www.blogrankings.com/img_51905.gif" alt="Finance Blogs - Blog Rankings" /></a> </th> <th scope="col"><a rel="nofollow" href="http://www.blogcatalog.com/directory/education-and-learning/" title="Growth and Education Blogs - BlogCatalog Blog Directory"><img src="http://www.blogcatalog.com/images/buttons/blogcatalog6.gif" alt="Growth and Education Blogs - BlogCatalog Blog Directory" width="57" height="47" style="border: 0;" /></a></th> <th scope="col"><a rel="nofollow" href="http://www.mexicoweb.com.mx/"><img src="http://www.mexicoweb.com.mx/i3.gif" border="0" alt="El directorio y buscador de Mexico" /></a></th> <th scope="col"><a rel="nofollow" href="http://www.blogtopsites.com/finance/" title="Finance Blogs" target="_blank"><img style="border:none" src="http://www.blogtopsites.com/v_89689.gif" alt="Finance Blogs" /></a></th> <th scope="col"><a href="http://topofblogs.com/education_training"><img border="0" src="http://stats.topofblogs.com/send/74620" alt="TopOfBlogs" /></a></th> <th scope="col"><a rel="nofollow" href="http://www.yatzoom.com/">YatZoom</a></th> <th scope="col"><a rel="nofollow" href="http://www.hotelesbaratos.com/">Hoteles Baratos</a></th> </tr> <tr> <th width="95" scope="col"><a href="http://www.ebooking.co.uk/">Ebooking</a></th> <th width="80" scope="col"></th> <th width="65" scope="col"><a rel="nofollow" href="http://directorio-peru.blogspot.com/">Directorio Perú</a></th> <th width="132" scope="col"><a rel="nofollow" href="http://www.dabooti.com/">Directorio Web</a></th> <th width="81" scope="col"></th> <th width="80" scope="col"><script src="http://cdn.wibiya.com/Toolbars/dir_0712/Toolbar_712494/Loader_712494.js" type="text/javascript"></script><noscript><a href="http://www.wibiya.com/">Web Toolbar by Wibiya</a></noscript></th> <th width="101" scope="col"><a href="http://www.alexa.com/siteinfo/ayudaexcel2010.blogspot.com"><script type="text/javascript" language="javascript" src="http://xslt.alexa.com/site_stats/js/t/a?url=ayudaexcel2010.blogspot.com"></script></a></th> <th width="114" scope="col"> </th> </tr></tbody></table>){kind=link}