TextToColumn when destination to other sheet

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
 
D

Dave Peterson

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.
 
C

CG Rosen

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...
 
Top