remove quotes and apostrophe from cell

Some videos you may like

Excel Facts

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.

tyija1995

Well-known Member
Joined
Feb 26, 2019
Messages
766
Office Version
365
Platform
Windows
Hey, try this:

=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(D3,"'",""),"""",""),"-","")
 

Watch MrExcel Video

Forum statistics

Threads
1,095,349
Messages
5,443,942
Members
405,256
Latest member
ukboyme

This Week's Hot Topics

Top