Go Back   Access World Forums > Apps and Windows > Excel

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 07-11-2018, 09:40 AM   #16
LadyDi
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

Perfect
Thank you

LadyDi is offline   Reply With Quote
Old 07-11-2018, 10:57 AM   #17
Gasman
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

Quote:
Originally Posted by arnelgp View Post
Gasman:
Just tested it again abd it does replace Drive with DR.
arnelgp,
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
Reply

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
General
Tables
Queries
Forms
Reports
Macros
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