Tom Hall wrote:
On Wed, 6 Sep 2006 10:54:47 -0400, "Bob Umlas"
wrote:

Text to Columns is something applied to ROWS, not Columns.

Wrong. It IS applied to columns. You highlight a single column containing
text data you want to alter.

Say you have a column of Firstname, Lastname combinations, and you want to
break out the last name to the next column over to the right. This is a
perfect scenario for Text to Columns and it takes only as long as it takes
you to highlight the column (or cells) that you want to run the routine on.


Tom

OK. There's some new information. I realized that converting a
worksheet into CSV then import it into a SQL Server db would work great
as well, something anyone else could also use in addition to the
technique that Dave Peterson has written.