I have the following list:
peter "dog"
jake "cat"
richard "horse"
nathan "sheep"
....etc (there are hundreds of them)
I would like to remove all strings contained within speech marks as wells as the speech marks themselves. so the list would become:
peter
jake
richard
nathan
....etc
How would I do this using VBA?
Many thanks in advance
Without VBA
CNTL + H
find "*"
replace by (leave empty)
replace all.
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.
great thanks. alot easier
Sub b() Set Rng = ActiveSheet.UsedRange Rng.Replace What:="""*""", Replacement:="", _ SearchOrder:=xlByColumns, MatchCase:=True End Sub
If solved remember to mark Thread as solved
thanks patel45. Question what exactly is UsedRange?
thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks