TextToColumn when destination to other sheet

  • Thread starter Thread starter CG Rosen
  • Start date Start date
C

CG Rosen

God day Group,

Is it at all possible to destinate the the split columns to another
worksheet when using the TextToColumn wizard? Can it be made
by code? When trying in the wizard I get the error message about
wrong destination reference.

Brgds

CG Rosen
 
I don't think so.

But you could copy the column range to a (separate, new, temporary) worksheet,
do the text to columns and put the parsed data where you want.
 
Thanks for info / cgr

Dave Peterson said:
I don't think so.

But you could copy the column range to a (separate, new, temporary)
worksheet,
do the text to columns and put the parsed data where you want.
Click to expand...
 
Back
Top