replacing

Hi All, I have some code which creates a "score" line within my spreadsheet. I need this formula to change each time I run my macro, as the number of questions it relates to is variable. I have the formula: Range("B" & LastRow + 3).Value =...

Hi I have several formulas in different cells. I wanted to show the formula not the value so I thought of adding ' to = I went to Home-->Find and replace--> = with '= It did work Then I wanted to do the reverse and replacing '= with = but I got error message saying could not find '= Is that...

I have read here: https://professor-excel.com/performance-excel-study/ that INDEX/MATCH or VLOOKUPS can be up to 50% faster than SUMIFS but for some reason I am having a hard time replacing a SUMIF formula with either Index/Match or Vlookup. Has anyone done this in the past...

Hey people, Could I ask some help on this please. I have put together a replace macro that reads a table to from an array to then find and replace data. Problem is, it keeps looping and replacing the data over and over. Help would be apprecited. I'm basiclly searching a list of 1-4 digit...

Hello All, Need help with replacing text as I have tried some formulas as well as a simple find & replace. I have a string within a cell: abc\Joe,abc\Mary,abc\harry,abc\,abc\,abc\ I want to remove the ,abc\,abc\,abc\ Any ideas? Thanks, Eric

The below code works well, and I do not necessarily need anything, but again, I've used the "Select" option in VBA, and was wondering how I could possibly remove the Select piece of this code. Like I said, it works fine and I have no problem with it, but if you have any suggestions on replacing...

Is there a way of replacing the (blank) that is in a pivot table cell when nothing is in the source cell with nothing? I linked a pivot table to an Access database the and the (blank) is showing up in the report. I was wondering if there was a way of getting rid of this so nothing would show...

Hi, I need to insert character in between a given string by replacing the character in the given string. Here is an example: Str = "ABTXDFATGTHYFL" Replacing A with Z So, the output would be "ZBTXDFZTGTHYFL" Thanks

Good day everyone Can someone please help me with the following... <tbody> A B 1 <tbody> http://www.xyz.co.za/ProdImg/AA13NDfl1uuL2c.jpg </tbody> <tbody> http://www.africaestore.com/esquire/AA13NDfl1uuL2c.jpg </tbody> 2 <tbody>...

Hi there, I need a formula that will find duplicate values from Column A and in Column C, then replace the cell value of Column D with the cell values of Column B. For example: Col A Col B Col C Col D AAA 0 BBB 15 BBB 5 LLLL 5 CCC...

<colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody> <colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody> Value Result $A1 $A2 $B3 $B4 $G4 SG5 $D4 $D5 </tbody> </tbody> I have the values in the "Value" Column...

So I have recorded a Macro that formats a column that does 3 things (removes all "-" from cells, multiplies every cell by 1, and also a text-to-column function). These are all to help with formatting to create a Vlookup. I will do this on many different spreadsheets but not necessarily the same...

Hi All<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p></o:p> I am trying to replace the link by month to an external workbook.<o:p></o:p> <o:p></o:p> In Excel 2003 I could use Find and Replace and search on \[Oct09.xls], and find almost 2000 entries...