Go Back   Access World Forums > Apps and Windows > Excel

Thread Tools Rate Thread Display Modes
Old 07-11-2018, 09:40 AM   #16
Newly Registered User
Join Date: Mar 2007
Location: North Canton, Ohio
Posts: 894
Thanks: 52
Thanked 1 Time in 1 Post
LadyDi is on a distinguished road
Smile Re: Macro and/or Formula to Find and Replace

Thank you

LadyDi is offline   Reply With Quote
Old 07-11-2018, 10:57 AM   #17
Enthusiastic Amateur
Join Date: Sep 2011
Location: Swansea, South Wales,UK
Posts: 3,040
Thanks: 341
Thanked 494 Times in 476 Posts
Gasman has a spectacular aura about Gasman has a spectacular aura about
Re: Macro and/or Formula to Find and Replace

Originally Posted by arnelgp View Post
Just tested it again abd it does replace Drive with DR.
I wasn't saying it did not. What I was asking is DRIV comes before DRIVE in the range, so I would have expected it to replace in the word DRIVE, DRIV with DR giving DRE.

That is what happened to my attempt, which made me realise that the order in the substitute range can matter.?

Edit: Not to worry, I have fiound out why now.

Access novice. Sometimes trying to give something back.
Access 2007

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.

Last edited by Gasman; 07-12-2018 at 02:58 AM. Reason: Updated with method found
Gasman is online now   Reply With Quote

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Find/Replace Macro DavetheVBNewb Macros 6 07-14-2009 02:31 PM
Find and Replace within a macro innocent_smoothie Macros 7 06-02-2009 12:58 AM
Find and Replace Macro Sorryaboutthemess Word 1 11-21-2007 07:22 AM
Find and Replace in a Macro susanmgarrett Macros 1 04-06-2006 12:35 PM
Find and Replace in a Macro susanmgarrett Macros 0 04-05-2006 01:10 PM

All times are GMT -8. The time now is 10:19 AM.

Microsoft Access Help
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post

Sponsored Links

Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World