remove special character

  1. Sufiyan97

    Remove special characters and numbers

    I want to remove any numbers (0 to 9) and special texts like * # - ; X from below data A1Description2CHECKCARD 1103 IN *J3 RESOURCES, 713-2900221 TX 55432860308200406920029 CKCD 7392 XXXXXXXXXXXX5599 XXXX XXXX XXXX 55993CHECKCARD 1105 eBay O*02-06012-0 San Jose CA...
  2. T

    SaveAs VBA Removing Special Characters

    Hello, I have the following code which names a sheet after a specified cell and then copies into a new workbook. The next stage attempts to save the workbook after another cell value however this is where I became stuck. Cell D2 can contain special characters so the save as isn't working...
  3. Z

    Remove Asterisk and extra space from cell

    Hi, I need to remove Asterisk and extra space from cell check this. <tbody> <tbody> Original Description After Clean Asterisk and Space Get a sparkly look with Our Signature Swarovski Crystal Teardrop Stud Earrings, faceted for extra shine in a delicious variety of colors finishes...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top