merging columns

  1. R

    Merging Columns and Missing Headers when Custom Sorting

    Hi there, So I'm pretty new to doing these 2 things & I read online that one can use Ablebits data to merge 2 columns, so that's what I used to merge the First/Last name columns. It worked fine on my first file, but on the second one, it's still showing column C as being attached to Column B...
  2. E

    Merging multiple non adjacent columns into one column

    Hi Can someone help with this, I have a worksheet with 62 columns of data, I want to take every other columns data and make one column eg Column A,C,E,G until AP each column has different amount cells of data so I want it so it doesn't leave a blank space when merged to one column say column...
  3. A

    copying cell A1, 10 characters into cell B1 - Partial merging

    HI, i have look but not sure the correct terms of what i need I have some urls i need to redirect for my site and there are hundreds and i wondered if it possible to take whatever is in column A, and paste it 10 characters into column B e.g., Cell A1 is pasted directly after Redirect / in...
  4. T

    Run-time error '13' Type mismatch

    Hi everyone, From what I already read on this forum this is a very common error but the existent threads didn't help me though. This is the first time I'm programming in Excel/VBA and I'm doing something really simple. I need this for image processing: I have two columns with x and y...
    • tania_r
    • Thread
    • error 13 merging columns mismatch error type mismatch
    • Replies: 2
    • Forum: Excel Questions

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top