Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Find and Replace
Ok, first off I just want to say thanks for all the help i have recieved
here. Every question I have asked i have gotten a great answer and it worked. So i really do appreciate it. To my question. I am trying to do a Find and Replace function: here is the example <b class="more-info-title"Starring: </bDanny Aiello, Glenne Headly, Jeff Daniels, James Spader, Greg Cruttwell, Teri Hatcher, Peter Horton, Marsha Mason, Paul Mazursky, Eric Stoltz<br<b class="more-info-title"Release Date: </b2/3/2004<br<b class="more-info-title"Director: </bJohn Herzfeld <br<b class="more-info-title"Rating: </bR<br<b class="more-info-title"Runtime: </b105 Minutes<br<b class="more-info-title"Note: </b DVD-FILMOGRAPHICS-SCENE ACCESS-TRAILER <br<b class="more-info-title"Overview: </b<br<brWhat do a cold-hearted killer, a crook who cooks, a drop-dead blonde, and two undercover cops have in common? Some of them are looking for sex. Some of them are looking for money. Some of them are just looking to stay alive. but all of them are looking to get out of the valley and they've got just two days to do it.<br I am trying to find "<b class="more-info-title"Overview: </b<br<br" and replace it to this "<b<b class="more-info-title"Overview: </b<br" but with my datebases of 43,000 + cells, that this will be replacing it gets through 26 cells then i get an error that says "Formula is too Long" is there another way to make it continue to run or is there another way to do that? Thanks again for any help you could provide? |
#2
|
|||
|
|||
How about a macro solution:
http://groups.google.co.uk/groups?th...apeXSPAM.c om It was written for a similar question, but if you modify the: BeforeStr = "1st Q" AfterStr = "2nd Qtr" to what you want, it may work. If you're new to macros, you may want to read David McRitchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm Mcobra41 wrote: Ok, first off I just want to say thanks for all the help i have recieved here. Every question I have asked i have gotten a great answer and it worked. So i really do appreciate it. To my question. I am trying to do a Find and Replace function: here is the example <b class="more-info-title"Starring: </bDanny Aiello, Glenne Headly, Jeff Daniels, James Spader, Greg Cruttwell, Teri Hatcher, Peter Horton, Marsha Mason, Paul Mazursky, Eric Stoltz<br<b class="more-info-title"Release Date: </b2/3/2004<br<b class="more-info-title"Director: </bJohn Herzfeld <br<b class="more-info-title"Rating: </bR<br<b class="more-info-title"Runtime: </b105 Minutes<br<b class="more-info-title"Note: </b DVD-FILMOGRAPHICS-SCENE ACCESS-TRAILER <br<b class="more-info-title"Overview: </b<br<brWhat do a cold-hearted killer, a crook who cooks, a drop-dead blonde, and two undercover cops have in common? Some of them are looking for sex. Some of them are looking for money. Some of them are just looking to stay alive. but all of them are looking to get out of the valley and they've got just two days to do it.<br I am trying to find "<b class="more-info-title"Overview: </b<br<br" and replace it to this "<b<b class="more-info-title"Overview: </b<br" but with my datebases of 43,000 + cells, that this will be replacing it gets through 26 cells then i get an error that says "Formula is too Long" is there another way to make it continue to run or is there another way to do that? Thanks again for any help you could provide? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find and Replace - Quickest Option? | Excel Worksheet Functions | |||
Using Find and Replace All | Excel Worksheet Functions | |||
find replace cursor default to find box | Excel Discussion (Misc queries) | |||
macro to Find Replace in Excel | Excel Discussion (Misc queries) | |||
VB Find and Replace | Excel Worksheet Functions |