TIP - 48 : Selection of destination for text to columns

Selection of destination for text to columns

Where we have data in different columns and you want to use text to columns, but it should not overlap on the immediate or adjacent columns, then here comes the solution. The advantage is that the data of original column will be remains same.

Step 1: Please select the data that we want to do text to columns, click on Text to Columns from Data Tab

Step 2: From the dialogue box Text to Columns Wizard, click of your choice Delimited or Fixed width

Step 3: Click on next, select the delimiters then click on next again

Step 4: Now select “Destination” and click the cell where you want to place your data, finally click on Finish