aa3

  1. userxyz777

    Find & Replace w/difficult edge cases

    Hello everyone, I have a find place problem I do not have the skills to solve I want to replace all the commas + space ", " with a pipe | I have some column data in a sheet called Have that looks like the following, where "one" is the column header <tbody> one aa2 aa3, aa1, aa5 aa1...
  2. C

    Pivoting repeated strings

    Sorry if the title isn't descriptive I honestly had no clue how to quickly say what I'm working on.Hello, thanks very much in advanced for the help. Basically I have a long list with two columns, the first column has a word and the second a string of numbers. I would like to automatically...
  3. C

    cell reference

    Cell U3 has the formula =j1482. I would like cell AA3 to look at cell U3 and return the formula =p1482. That is, in cell AA3, I would like to substitute the column reference "j" for "p" but keep the row reference 1482 shown in U3.
  4. B

    Splitting excel sheets (Not copy paste data range) into separate workbooks with a certain name

    I have a workbook with multiple sheets that have a name in column AA3 which might match in 2 or more sheets. The macro needs to search these cells and club all sheets with a similar name in AA3 and then make a new workbook out of them using the same name. Please advise a solution.

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