I have a database with number values and some of the values have *after them e.g. '463*. Is there any quick way to remove the * but keep the number without having to go through every cell and check. Find does not work with *. I need to use the sheet to do macro coding and the code wont work witht he * in.
Any help would be appreciated!
Hi.
Could you post a sample data file?
Click *, if my suggestion helps you. Have a good day!!
I could send a mock one? An example would be BA2-BA65 - 2, 4, 5, 6, '75*, 8, 9, 10, 11, '8*... other number. If that makes any sense :/
Thank you!
Try this macro:
findandreplace.xlsm
=substitute(a1,"*","")
Regards,
abdul
Whenever you are finding the wildcard characters then add ~ in front of the character like thisOriginally Posted by Laura343
In Find What Box
Formula:
Please Login or Register to view this content.
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
hi Laura343, welcome to the forum. select the range you want to replace, then press CTRL + H.
Find What:
~*
Replace with:
so it's finding "~*" & replace with nothing. the tilde sign is for you to really find asterisk instead of a wildcard
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
Why not try Find/Replace
Select your range/column
Find what:=
Formula:Please Login or Register to view this content.
Replace with:=
Leave blank
* on its own is a wild card and will clear everything
by preceding it with tilde (~) ,Excel looks for the character * only.
If you have also leading apostrophes use Find/Replace again
Text to Columns can also do this, use * as your delimiter.
If you need any more information, please feel free to ask.
However,If this takes care of your needs, please select Thread Tools from menu above and set this topic to SOLVED. It helps everybody! ....
Also
اس کی مدد کرتا ہے اگر
شکریہ کہنے کے لئے سٹار کلک کریں
If you are satisfied by any members response to your problem please consider using the small Star icon bottom left of their post to show your appreciation.
Hi,
Your Macro did work however I need the numbers with the stars to be replaced in the same cell. Thank you though!
Thank you thats great! I only want to delete the * from the end of the numbers I have in the cell. So now I can find the numbers with * on the end but is there a way to get rid of the * without going through each one seperatly? Thank you for your help!
Make use of REPLACE ALL button
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks