is it possible to create a VBA to find the last underscore in highlighted cells, and move that underscore to 1 character left?
For example,
MOV_112A_BC
into
MOV_112_ABC
Only the 2nd '_' should move 1 character to the left.
is it possible to create a VBA to find the last underscore in highlighted cells, and move that underscore to 1 character left?
For example,
MOV_112A_BC
into
MOV_112_ABC
Only the 2nd '_' should move 1 character to the left.
What do you men by "highlighted cells": Is it the selected cells ?
- Battle without fear gives no glory - Just try
If it is then try
Please Login or Register to view this content.
=replace(c66,8,4,"")&"_"&mid(c66,8,1)&right(c66,2)
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Thanks PCI, it worked!
Will try and understand the code tonight.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks