Hi, I'm using search & replace in a macro but only want to replace the text if it is in the first 3 letters within the cell. So, for example, I currently have;
Please Login or Register to view this content.
This is to delete the text "DS" but obviously it's deleting DS anywhere within the text rather than just at the beginning of the text.
any help much appreciated.
Liam
Last edited by LiamF; 07-30-2010 at 06:57 AM.
Hi LiamF
maybe something like
Please Login or Register to view this content.
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save
Since you already have your code, add this about the code (but change the column to the column your data is in...
Your finished code will look like this....Please Login or Register to view this content.
Please Login or Register to view this content.
Hi Shaner73
Doesnt the code will still replace DS any where in the text?
I thinkshould be replaced withPlease Login or Register to view this content.hthPlease Login or Register to view this content.
Ajay
Hmmm. same problem with samples
DSAAAA
AADSAA
AAAADS
Sorry, I missed the following in original post.
replace the text if it is in the first 3 letters
Hi ajaykgarg
No that doesnt work
Please Login or Register to view this content.
Pike, you are correct. I didn't read the original post well enough. I took his post as "DS" was being removed from all columns and rows. My apologies.
In the mean time, I'm looking to see if I have anything else that may be able to help him.
Perhaps something like this
HTHPlease Login or Register to view this content.
Alf
Last edited by Alf; 08-04-2010 at 04:15 PM. Reason: Better answar
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks