View Single Post
  #12   Report Post  
Posted to microsoft.public.excel.misc
Tom Hall Tom Hall is offline
external usenet poster
 
Posts: 17
Default "Text to Columns" for many columns in Excel 2003

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

--
remove .spoo to reply by email