remove numbers

  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. Tosborn

    Remove selected numbers from text & number string

    Howdy, Data is typically as such: <tbody> <colgroup><col width="389"></colgroup><tbody> 25MAR16 CHAMPS FLOWERS HMP WAGGA W 67.00 1,037.00- </tbody> <colgroup><col width="389"></colgroup><tbody> 01APR16 HUNTERS NEWSAGENCY WAGGA W 821.00 1,858.00- </tbody> <colgroup><col...
  3. L

    How do you remove specific digits from a cell

    Hello, I have a list of numbers (formated as text) that are 12 digits long. I need to remove the 3 digits prior to the last one (or the 9,10, and 11 digit). Is there a formula for that? For example, my number is: <tbody> 120184160013 I need it to be: 120184163 </tbody>
  4. D

    Remove numbers from text and add new line to separate two strings based on delimiter in a cell

    <tbody> Actual Result london#123;new york#34; london; new york; delhi#145;chennai#54; delhi; chennai; hyderabad#748; hyderabad; Mumbai#456;Pune#234;Kerala#120; Mumbai; Pune; Kerala; </tbody> Hello All, Can you please help me in removing the # and numbers from text and add new line...
  5. D

    Remove random series of #'s from the end of a cell

    Hello, I'd like a way to remove numbers from the end of each cell. For example: <table style="width: 511px; height: 189px;" border="0" cellpadding="0" cellspacing="0"><col style="mso-width-source:userset;mso-width-alt:10788;width:221pt" width="295"> <tbody><tr style="height:12.75pt"...

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