TextToColumns Destination:=another worksheet

  • Thread starter Thread starter Geof Wyght
  • Start date Start date
G

Geof Wyght

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.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

sub TextToColumns 1
Automatically Accept Replace Values in Text-to-Columns macro 2
TextToColumn when destination to other sheet 4
Replaceing destination cell contents with new data in Excell 3
Text to Columns with multi-character delimiters 2
Importing text files asa group 1
defining TextToColumns with variable 2
TextToColumns Method - Delimited by Double Spaces 4

Back
Top