excel columns rows

  1. G

    Hide a selection of columns within a range

    Hi All, I am stuck. I have a Range of columns Range(C:AA) Each Column Header has a calendar month starting 01/01/2020 to YTD 2020 and continues 01/01/2021 to YTD 2021. Each month, I need to have a macro that hides a set of columns. For Example: I select Jan Columns C (Jan-20); Column L...
  2. E

    Remove partial data within each Row, HOW??

    I am very new to Excel so please excuse the limited knowledge of asking this question within this community. I have a Column that contains website in each row. I need to remove ALL details except the final domain. Basically, only need domain data AFTER the following phrase: url= Some...
  3. E

    Column Row, move some row data, how??

    I am very new to Excel so please excuse the limited knowledge of asking this question within this community. I have a Column that contains emails in each row, however SOME of the rows contain the website url as well. I can't figure out HOW to separate the website into its own column while...
  4. E

    Sorting or Arranging Columns with incorrect Row data

    I am very new to Excel so please excuse the limited knowledge of asking this question within this community. In Excel spreadsheet I have Twenty plus Columns, each with Headers, Example, Name, Email, Category, Phone, Address. Within each row down the column includes the marker and following...
  5. D

    cleaning up a database, moving variable rows into columns

    Hi, I have a large spreadsheet that I pasted from a website. There is a column of names (column A) that is associated with a column of street addresses (column B). For some reason the addresses appear as rows of data. For example A2 is John Doe, A3 is blank, A4 is blank, B2 is 15 South...

Watch MrExcel Video

This Week's Hot Topics

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
Top