We have a program that generates a text file where some of the names start with the * symbol. I would like to remove all of them so I can alphabetize the list, but if I try to use "Find and Replace" it clears everything (I am guessing Excel uses * as a wild card?). Is there a way to do this, or do I need the programmers to change the symbol they use? If we change the symbol would the dollar sign be safe to use?
"Laugh? I thought I'd die!"
Jimbo?
sort the column and remove the range is the easiest way
Try a Find/replace with ~*
Find ~*
Replace nothing
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Sorry I want this removed it was meant for another topic.
Last edited by billgyrotech; 01-06-2017 at 05:50 PM.
Billy, what do you want removed?
I posted a formula to remove duplicate rows. It was for another topic sorry.
You mean post #2?
No I already edited it out. One of those days sorry for the trouble.
FDibbins - That was exactly what I needed!! Thank you very much!
@ Bill no problem
@ Jim, awesome, happy to help, thanks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks