Thread: Text to Rows?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
RicardoE RicardoE is offline
external usenet poster
 
Posts: 5
Default Text to Rows?

Hello,

I can't find info on how to split up the comma-delimited contents of a cell
into multiple rows rather than columns. Is this possible? Could a Macro do
it? If so, any samples?

For example, my cell contents currently a "C346,C349,C362"
I would like to split them up as:

C346
C349
C362

Rather than into individual columns, as Text to Columns would do.

Thanks,

Ricky.