Select your range (but it has to be a single column) of 200 cells.

Then click on Data|Text to columns.

And follow the wizard.

NickName wrote:

Bob Umlas wrote:
Text to Columns is something applied to ROWS, not Columns. It distributes
data in several rows (or one) across columns, so something like
1,2,3,4,5,6 would get distributed to columns A:F if the comma were the
delimiter, for example.
Your question doesn't really apply here, unless I'm misunderstanding the
question.

Then what's an efficient way to apply the "Text to Columns" feature to
many
many (say, 200) rows in Excel 2003? btw, the naming of this feature is
misleading, it would be more accurate if named something like "Convert
to Text" regardless of Column or Row but forget about this.

Also, copying a cell's format and past special (for the format to a
range of cells) would not work, weird.


"NickName" wrote in message
oups.com...
Hi,

What is an efficient way to apply the "Text to Columns" feature to many
many (say, 200) columns in Excel 2003? A macro? If so, can I see some
sample code for that?

TIA.


--

Dave Peterson