reformat cells

  1. R

    Search a range for a specific color of rows, relocate those cells to another sheet, return previous sheet formatting to blank and sort secondary sheet

    So, this is a mouthful. I have a spreadsheet that tracks the statuses of my jobs. I need to be able to click on the sort button sort that sheet by color and relocate all completed work to a secondary sheet where it will be amended after the last row and sorted, also this code needs to reformat...
  2. E

    Clean up and reformatt large data set

    Hello, I was wondering if I could get some help please. I am attempting to reformat a large set of data to load into qlikview. At the moment there are multiple columns with values on one line separated by a comma. I would like to find a way to separate the data for all of the columns. I have...
  3. B

    Reformat Data

    I have data that has goes out to the right with Year columns. One record with many year columns. What I need is many records with one year column. I am trying to figure out if there is some way to 'automate' this process. Or at least a way to simplify the process. I have 30 columns of...
  4. P

    Extracting name of person, Phone Number, and Address from a column of cells and paste into separate Cells

    I am using Excel 2010 and 2013. I have a list of names, phone numbers, and addresses in 1 column. Each cell contains a persons name, Telelphone number, and Home address. John Doe (xxx) xxx-xxxx yyyy Street Name City Name Postal Code Currently the list of information is in Column B. I would...

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