search and replace string

  1. C

    Is this even possible...???

    n00b here, LOL, I need help in a certain formula or whatever, to like, ya know... Ok... *breathes deeply* ... so like... Here, let me explain what I am looking for... I am looking for a formula that shows results in Cells(A2:D2) from a range in another sheet (A2:D7) based on whats being typed...
  2. N

    Using search and replace is changing the cell format

    I am using excel 2007. I have around 9K rows and 5 columns of data. The first column has one or two words in bold and punctuated by a full stop and rest of the words in this column is separated by a comma and is of a regular font without any formatting. I want to replace all such comma with a...
  3. D

    How to replace just a single character from many of the same one within a text?

    Hi folks, I have to deal with a text database into Excel but ended up finding irregular format that need to be fixed. As it can be seen within the text right below, there are space delimiters in between the words. I want to replace always the 2nd space from right to left with a semicolon...
  4. A

    VBA Search for non-empty cell. insert random number on next cell

    Hello All, I have had a good forum/Google search to try and work this problem out, but had no luck. It has been too long since I have used VB and I've forgotten how to do basic things. I'm looking for VBA code to do the following: Search Column B (after B1) for non-empty cells. If the cells...
  5. A

    .TXT Batch replacing Macros

    I am looking for a Macro that replace my text files. It should be able to search a same work from all txt files and replace it with a different word for each file. For example I have same word "TEXT" in all my 1000 files, I want to replace this word in each file by a different word like...
  6. C

    search and replace parts of a string

    Hoping someone can help me make my macro run more efficiently. I am wanting to search for a string (code) in a specific column. Once I find it, I want to replace it with the correct text. sample code: oc_L2_5_4 text replacement: Online Content, Lesson 2-5 p. 4 The underscores are used to...

Some videos you may like

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