porter

  1. D

    Help removing characters in a cell

    So here is my dilemma and it is driving me nuts. Starting Cell possibilities: "FM. Porter Jr. INACT " "FM. Porter Jr. GTD " "FM. Porter Jr. OUT " Desired Output: "M. Porter Jr." There is a space before and after "INACT"/"GTD"/"OUT". Some have "Jr." or "III" or nothing after the name. My...
  2. I

    Formula needed

    I run a report that I export into excel and it will have multiple names in one column separated by a comma. How can I move the crew members into their own column? <colgroup><col><col span="3"></colgroup><tbody> Current COLUMN A...
  3. P

    Auto find and replace

    Hi, I was wondering if it's possible to have Excel auto find and replace text that has been pasted into a spreadsheet. For example I'd like to paste: John Smith C.J. Davis Dave Porter But have Excel automatically change it to: Johnathan Smith CJ Davis Dave Porter Jr. I've tried adding new...
  4. A

    VBA Copy and Paste issues - skips blank cells unintentionally.

    Hi, I've created a workbook that when requested, copies data and pastes it into other workbooks. When pasting, i want it to go to the next available blank row - which it does great on the first sheet it opens, but the second it skips to row 120 odd and pastes it down there, even though...

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