Dear Experts,
Can some one give me vba code to replace only one character from string.
For example:
My - Name - is - Ali
*remove the first "-" only and replace it by "/"
so the result will be, My / Name - is - Ali.
Thanks
Dear Experts,
Can some one give me vba code to replace only one character from string.
For example:
My - Name - is - Ali
*remove the first "-" only and replace it by "/"
so the result will be, My / Name - is - Ali.
Thanks
This seems to work...
Please Login or Register to view this content.
Hi,
RgdsPlease Login or Register to view this content.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star icon below the post.
Please Login or Register to view this content.
Can I please have a code to do the same thing except to a whole column or range?
something like this
for each cell in selectionPlease Login or Register to view this content.
Best Regards
MaczaQ
---------------------------------------------------------------------------------------------------------------------------
If you are satisfied with the solution(s) provided, please mark your thread as Solved
If you are pleased with my answer consider to rate it. To thank someone who has helped you, click on the star icon below their name.
- This way you will add him some reputation points ... thanks in advance.
Name the range you want to carry out the macro (i've named it "range1") and it should find and replace all cells within the defined range
Please Login or Register to view this content.
So for Column A, just do Range("A:A")?
just columns(1) or columns("a")
Thank you!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks