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: 893
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
Access newbie
 
Join Date: Sep 2011
Location: Swansea, South Wales,UK
Posts: 2,069
Thanks: 263
Thanked 309 Times in 294 Posts
Gasman will become famous soon enough Gasman will become famous soon enough
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

Last edited by Gasman; 07-12-2018 at 02:58 AM. Reason: Updated with method found
Gasman is offline   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 03:58 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Sponsored Links

How to advertise

Media Kit


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