replace text

  1. 1

    Recorded vba for "replace text" does not work

    Hi, I have some VBA code that loops through column D and uses the values in range B:X. My problem is that sometimes, the value in some of the cells will have the error #DIVISION/0!. This stops my loop and creates an error. My solution to this was to put the below code before rendering the rest...
  2. P

    VLOOKUP Replace Text of Array Name with New Text

    I have 2 spreadsheets. Spreadsheet "b" has multiple arrays defined. I want to bring values from these arrays into spreadsheet "A". I have an existing VLOOKUP statement that accomplishes the basic purpose. Here is an example: =VLOOKUP(E70,'Quotes+Orders_Worksheet_2018.xlsx'!NWINTLAY120,3)...
  3. J

    Replace text within formula - with "dynamic" absolute reference to cell 1 row above

    Okay.. this is kind of a tongue twister but... I need to replace the text "$D$26" within column D with an absolute reference to the cell address of *the cell 1 row above* the cell containing this formula. The formula will appear every 10 rows. I have the code below, that seems to work but... I...
  4. Q

    Stripping out certain words from start of cells

    Hi I'm new to this forum, and hope someone might be able to help me. I have a range of about 5000 rows, each representing a title of an article, and I need to be able to strip out the words "The ", "Les", "A ", "Le ", "La " or "An " if they are at the start of each title. So e.g. I start with...
  5. D

    Replacing a single row in a table with multiple related values

    I am trying to break down the following 2-column table to include only each 'FinishedGood' and all its 'Inventory Parts' broken down to the 'Component' level. I want to replace each 'SubAssembly' Inventory Part with its corresponding 'Components': Source Format: <tbody> Assembly Item...
  6. T

    Macro to delete all data contained within <>

    I am working on an large excel workbook. On of the coloum contains email addresses, we want to clean it up to just show the name - is there a formula that would find and replace the information contained within <> with a space? Ex. T. Copeland<copeland@yahoo.com) - I only T. Copeland to...
  7. T

    Clear Chevron Characters and Characters Inside Chevrons

    Happy New Year, Excel folks. Is there an Excel formula to remove the spacebar + characters in red, as shown below? I need to be left with only the last name, first name and the semicolon. Mouse, Mickey <mickey.mouse@d.com>; Microsoft Outlook has changed the way that email addresses from...
  8. W

    Cells.Replace question: How do I replace text in one specific Column?

    Dim Lastline As Long Dim i As Integer Lastline = Cells(Rows.Count, 1).End(xlUp).Row For i = 1 To Lastline Cells.Replace _ What:=Sheets("Sheet1").Cells(i, 1), Replacement:=Sheets("Sheet1").Cells(i, 2), _ LookAt:=xlWhole, MatchCase:=False Next End Sub As per the following code, how do I...
  9. F

    Small snag with non-alphanumeric replacements

    Hi all! I was to change "[" and "]" in the same cell to "-". However, my code does not seem to be able to replace the second bracket in the same string. My Code: Sub DataParseSVOC() ' ' Routine for parsing 2008-2009 UATMP SVOC data ' Dim LR As Long Dim Itm As Long Dim MyCount As Long Dim...
  10. M

    [help] VBA Replace in Text won't finish at the end of text

    Hi, i want try to change some character in one cell with replace functions in VBA to another cell. every rows seem ok but at 13th row. i miss full code. not fully code can't be replace and severed at the end of code. Dim p As String Set a = ActiveWorkbook.Sheets("temp") i = 1 While...

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