If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
TextToColumn when destination to other sheet
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 |
#2
|
|||
|
|||
TextToColumn when destination to other sheet
Only the current sheet is possible
-- Gary''s Student - gsnu200908 "CG Rosen" wrote: 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 |
#3
|
|||
|
|||
TextToColumn when destination to other sheet
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. CG Rosen wrote: 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 -- Dave Peterson |
#4
|
|||
|
|||
TextToColumn when destination to other sheet
Thanks / cgr
"Gary''s Student" skrev i meddelandet ... Only the current sheet is possible -- Gary''s Student - gsnu200908 "CG Rosen" wrote: 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 |
#5
|
|||
|
|||
TextToColumn when destination to other sheet
Thanks for info / cgr "Dave Peterson" skrev i meddelandet ... 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. CG Rosen wrote: 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 -- Dave Peterson |
Thread Tools | |
Display Modes | |
|
|