Related Posts
Date ideas in Charlotte?
Has anyone rescinded an offer?
Additional Posts in Excel Genius
Anyone have a good source to learn sql
Everyone: Excel is a smart app
Excel:

Would anyone be willing to teach me vlookup?
New to Fishbowl?
Download the Fishbowl app to
unlock all discussions on Fishbowl.
unlock all discussions on Fishbowl.





Man you guys are lazy, just help the guy out or don’t comment. =substitute(substitute(substitute(substitute(reference cell, “)”,””),”(“,””),”-“,””),” “,””)
Copy or drag down on all fields you want used and it will calculate the format you are looking for.
This is the best answer, the substitute formula is money especially when you just want to get rid of unwanted characters. If there are blank leading or trailing spaces OP you could also add:
=TRIM(CLEAN(*the working substitute formula*))
Few different options. You can always Find each character and replace with blank (not a space).
Coach
OP I think it would help if you tried the solution first and also look at all the options that Excel gives you before reacting. You can find and replace all from that menu.
Mentor
Mid and right formulas.
Text to columns then recombine
Power query.
Okay so hear me out, I'm a noob at this & that helped but didn't help
NVM, I FINALLY GOT IT TO WORK. I really am a noon 🥲 thank you to everyone who gave suggestions. I've literally been trying to figure this out since last week. ChatGPT didn't even recommend this 🤣
Glad you figured it out. The other way you could do this is with formulas, specifically substitute function. For example, =substitute(a1,”-“,””) will replace dashes with nothing, thus giving you back the phone number without dashes.
ChatGPT can help you
you’re VERY good with AI and not with excel? interesting haha
This thread sounds like a troll. But if not, and a find replace all function is over your head, you really need to do some basic excel training.
Highlight and replace blanks and parentheses with blank no spaces if that makes sense lol
Not an excel guru, I would try this: =substitute(cell to change,"(","")
Download vsc code and have chatgpt write you a python script to do it. It will be done in ~10 seconds lul.
I kid you not
Text to columns on ()- and the recombine using concatenate formula
Have you tried ctrl+E
=SUBSTITUTE (SUBSTITUTE (A1," (“,”“),”)“,”")
Or
=TEXTJOIN (“”,TRUE,IFERROR (MID (A1,ROW (INDIRECT (“1:”&LEN (A1))),1)*1,“”))