s
s
aiks
ls
s
s
s
ehk
s
s
os
s
ns
s
s
s
s
aiks
ls
s
s
s
ehk
s
s
os
s
ns
s
s
I have that on a1 as raw data , i want the macro to delete all consonants and remains with vowels
------------------Deleted
Last edited by Sintek; 04-09-2017 at 11:02 AM. Reason: Found error in code
Good Luck...
I don't presume to know what I am doing, however, just like you, I too started somewhere...
One-day, One-problem at a time!!!
If you feel I have helped, please click on the [★ Add Reputation] to left of post window...
Also....Add a comment if you like!!!!
And remember...Mark Thread as Solved...
Excel Forum Rocks!!!
5B:
![]()
Please Login or Register to view this content.
1. I care dog
2. I am a loop maniac
3. Forum rules link : Click here
3.33. Don't forget to mark the thread as solved, this is important
@ karedog
Please put me out of my misery.....Assume that the information was in Column A1 down and not just in A1 so i.e A1 = "s", A2 = "s" A3 = "aiks" etc
How does this code have to be altered to work.
![]()
Please Login or Register to view this content.
@ karedog
I was trying to make use of MickG's code for the post problem and could not even get that to work.
![]()
Please Login or Register to view this content.
Are you sure you should be using Len("A" & i) in the inner loop?
If posting code please use code tags, see here.
@ Norie
I dunno...I'm lost....Being trying to figure out why !!!!
I'm trying to loop through A & i then loop through the characters of A & i
Is it the characters in the string A & i you want to loop through or the characters in the string in Range("A" & i)?
PS When deleting it's normally a good idea to loop backwards.
Hi Norie
the characters in the string in Range("A" & i)
So this,
should be this.![]()
Please Login or Register to view this content.
![]()
Please Login or Register to view this content.
Oh my gosh...Really....Still so much to learn...Would never have figured that out...
So code that works if info was in column...Thanks Norie
![]()
Please Login or Register to view this content.
And MickG's code to solve the thread problem
![]()
Please Login or Register to view this content.
This UDF might work
![]()
Please Login or Register to view this content.
_
...How to Cross-post politely...
..Wrap code by selecting the code and clicking the # or read this. Thank you.
@sintek,
Sorry for the late, but I see you have figured it out by yoursef. Good job.![]()
Should be
otherwise it leaves pipe.![]()
Please Login or Register to view this content.
Should be
it also leaves comma.![]()
Please Login or Register to view this content.
What is the final version , to pick , that will do the needful
I would go for this one.
![]()
Please Login or Register to view this content.
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks