replace reference value

  1. J

    Replace part of file name in a formula based on sheet name

    I'm really hoping someone could help me out with this one. Here is my situation: I have a workbook with several sheets, all set up exactly the same. Each cell on a sheet is referencing the same file, however each sheet is referencing a different file. For example, this is one of the cells in a...
  2. I

    Replace one column data with data from another column

    Hi, I'm looking for a desperate answer regarding my problem, so if you have any suggestion please help: I have 3 columns who look like this: A B C <tbody> PT 199 Bragareasa PT 199 Bragareasa PT 199 Bragareasa 6 IND PT 130 Grindu 11IND PT Parc 5 Grindu 7/483 IND PT 5 Grindu 378...
  3. M

    Use row number as factor in calculation, replace original values

    I'm trying to determine the VB for a macro that will replace the values in a column by the the results of the calculation of that same value + (row number/ 100000). At the present, I am creating an additional column and using the following formula: IF(E2>=1, (E2+(ROW(E2)/10000000000)), "")...
  4. poitbot

    Macro to use cell references and text to replace words in workbook

    Hello, I have data listed in a worksheet that contains text in the first column that needs to be replaced throughout the entire workbook. The data looks similar to this: Sun, $D$8#Home, $B$42#WWB, $B$3#Definitions Earth, $D$18#Summary, $B$3#Page 1, $B$42#Classroom Ball, $E$27#Home, $B$4#WWB...
  5. R

    Phone Number Format Changes

    I have phone numbers entered in the (222) 333-4444 format and need to change them to the 222-333-4444 format. Is there a Find/Replace or other formula that can accomplish this? If so, please provide an example. Thx!
  6. R

    Replace cell reference with value

    Hi, I have inherited a rather large worksheet that contains multiple columns of the style: AC1=($B$1-Q1)/($B$11-1) AC2=($B$1-Q2)/($B$11-1) AD1=($B$1-R1)/($B$11-2) where Q1,R1 etc. are static values. I would therefore like to replace the references to these cells with the values...

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