Copy all of the cells from the original column to the first new column. Select the character that divides the data. Depending on your data, this could be a space, a comma, a dash or another character.
You can Merge and combine columns without losing data in Excel using the following two methods: Using an Operator Using the CONCATENATE formula. Let us see both these methods in detail. While using ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results
Feedback