TextToColumns Destination:=another worksheet
 

Does anyone know whether I can do TextToColumns to a worksheet other than
the one I'm processing? It doesn't appear so, but I want to make sure.
Thanks.
Geof.

TextToColumns Destination:=another worksheet
 

Geof,

You need to copy or cut/paste the original data to the new worksheet prior
to doing the conversion.

HTH,
Bernie
MS Excel MVP

"Geof Wyght" wrote in message
...
Does anyone know whether I can do TextToColumns to a worksheet other than
the one I'm processing? It doesn't appear so, but I want to make sure.
Thanks.
Geof.